Microsoft Power BI

Explore the interactive ERD

Table & Field Reference

refresh_schedule

Column	Type	Keys
`_fivetran_id`	String	PK
`dataset_id`	Unknown	FK
`days`	Json
`enabled`	Boolean
`local_time_zone_id`	String
`notify_option`	String
`times`	Json
`workspace_id`	Unknown

capacity_admin

Column	Type	Keys
`index`	Unknown	PK
`capacity_id`	Unknown	PKFK
`admin`	Unknown

capacity

Column	Type	Keys
`id`	Unknown	PK
`access_right`	Unknown
`display_name`	Unknown
`region`	Unknown
`sku`	Unknown
`state`	Unknown
`tenant_key_created_at`	Unknown
`tenant_key_id`	Unknown
`tenant_key_is_default`	Unknown
`tenant_key_name`	Unknown
`tenant_key_updated_at`	Unknown
`tenant_key_vault_identifier`	Unknown

dataset_user

Column	Type	Keys
`identifier`	String	PK
`dataset_id`	Unknown	PKFK
`dataset_user_access_right`	String
`display_name`	String
`email_address`	String
`graph_id`	String
`principal_type`	String
`profile`	Json
`user_type`	String

dashboard_tile

Column	Type	Keys
`id`	Unknown	PK
`dashboard_id`	Unknown	PKFK
`dataset_id`	Unknown	FK
`report_id`	Unknown	FK
`col_span`	Unknown
`embed_data`	Unknown
`embed_url`	Unknown
`row_span`	Unknown
`title`	Unknown

dashboard

Column	Type	Keys
`id`	Unknown	PK
`app_id`	Unknown	FK
`workspace_id`	Unknown	FK
`display_name`	Unknown
`embed_url`	Unknown
`is_read_only`	Unknown
`web_url`	Unknown

dataflow_user

Column	Type	Keys
`identifier`	String	PK
`dataflow_id`	Unknown	PKFK
`dataflow_user_access_right`	String
`display_name`	String
`email_address`	String
`graph_id`	String
`principal_type`	String
`profile`	Json
`user_type`	String

app

Column	Type	Keys
`id`	Unknown	PK
`workspace_id`	Unknown	FK
`description`	Unknown
`last_update`	Unknown
`name`	Unknown
`published_by`	Unknown

refreshable_configured_by

Column	Type	Keys
`index`	Unknown	PK
`refreshable_id`	Unknown	PKFK
`configured_by`	Unknown

refreshable

Column	Type	Keys
`id`	Unknown	PK
`average_duration`	Unknown
`count`	Unknown
`end_time`	Unknown
`failures`	Unknown
`groups`	Unknown
`kind`	Unknown
`last_refresh_attempts`	Unknown
`last_refresh_end_time`	Unknown
`last_refresh_extended_status`	Unknown
`last_refresh_id`	Unknown
`last_refresh_request_id`	Unknown
`last_refresh_service_exception_json`	Unknown
`last_refresh_start_time`	Unknown
`last_refresh_status`	Unknown
`last_refresh_type`	Unknown
`median_duration`	Unknown
`name`	Unknown
`per_day`	Unknown
`refresh_schedule_days`	Json
`refresh_schedule_enabled`	Unknown
`refresh_schedule_local_time_zone_id`	Unknown
`refresh_schedule_notify_option`	Unknown
`refresh_schedule_times`	Json
`schedule`	Unknown
`start_time`	Instant

dashboard_user

Column	Type	Keys
`identifier`	String	PK
`dashboard_id`	Unknown	PKFK
`dashboard_user_access_right`	String
`display_name`	String
`email_address`	String
`graph_id`	String
`principal_type`	String
`profile`	Json
`user_type`	String

group_user

Column	Type	Keys
`index`	Unknown	PK
`workspace_id`	Unknown	PKFK
`display_name`	Unknown
`email_address`	Unknown
`graph_id`	Unknown
`group_user_access_right`	Unknown
`identifier`	Unknown
`principal_type`	Unknown
`profile`	Unknown
`user_type`	Unknown

group_workbook

Column	Type	Keys
`index`	Unknown	PK
`workspace_id`	Unknown	PKFK
`dataset_id`	Unknown	FK
`name`	Unknown

groups

Column	Type	Keys
`workspace_id`	Unknown	PK
`capacity_id`	Unknown	FK
`pipeline_id`	Unknown	FK
`capacity_migration_status`	Unknown
`dataflow_storage_id`	Unknown
`default_dataset_storage_format`	Unknown
`description`	Unknown
`has_workspace_level_settings`	Unknown
`is_on_dedicated_capacity`	Unknown
`is_read_only`	Unknown
`log_analytics_workspace`	Unknown
`name`	Unknown
`state`	Unknown
`type`	Unknown

refresh_history_attempt

Column	Type	Keys
`attempt_id`	Unknown	PK
`refresh_history_workspace_id`	Unknown	PK
`refresh_history_dataset_id`	Unknown	PKFK
`refresh_history_request_id`	Unknown	PKFK
`end_time`	Unknown
`execution_metric`	Unknown
`service_exception_json`	Unknown
`start_time`	Unknown
`type`	Unknown

refresh_history

Column	Type	Keys
`request_id`	Unknown	PK
`workspace_id`	Unknown	PK
`dataset_id`	Unknown	PKFK
`end_time`	Unknown
`refresh_type`	Unknown
`service_exception_json`	Unknown
`start_time`	Unknown
`status`	Unknown

event_activity

Column	Type	Keys
`id`	String	PK
`capacity_id`	String	FK
`dataset_id`	String	FK
`report_id`	String	FK
`workspace_id`	String	FK
`activity`	String
`activity_id`	String
`app_name`	String
`app_report_id`	String
`artifact_id`	String
`artifact_kind`	String
`artifact_name`	String
`client_ip`	String
`consumption_method`	String
`creation_time`	Instant
`distribution_method`	String
`is_success`	Boolean
`item_name`	String
`models_snapshots`	Json
`object_id`	String
`operation`	String
`organization_id`	String
`record_type`	Int
`request_id`	String
`user_agent`	String
`user_id`	String
`user_key`	String
`user_type`	Int
`workload`	String

pipeline_stage

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`workspace_id`	Unknown	FK
`orders`	Unknown

pipeline_user

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`access_right`	Unknown
`identifier`	Unknown
`principal_type`	Unknown

pipeline

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`display_name`	Unknown

dataflow

Column	Type	Keys
`id`	Unknown	PK
`workspace_id`	Unknown	FK
`configured_by`	Unknown
`description`	Unknown
`generation`	Unknown
`model_url`	Unknown
`modified_by`	Unknown
`modified_date_time`	Unknown
`name`	Unknown

app_user

Column	Type	Keys
`identifier`	String	PK
`app_id`	Unknown	PKFK
`app_user_access_right`	String
`display_name`	String
`email_address`	String
`graph_id`	String
`principal_type`	String

dataset_upstream

Column	Type	Keys
`dataset_id`	Unknown	PKFK
`workspace_id`	Unknown	PKFK
`dataflow_id`	Unknown	FK

dataset

Column	Type	Keys
`id`	Unknown	PK
`workspace_id`	Unknown	FK
`add_rows_api_enabled`	Unknown
`configured_by`	Unknown
`content_provider_type`	Unknown
`create_report_embed_url`	Unknown
`created_date`	Instant
`description`	Unknown
`is_effective_identity_required`	Unknown
`is_effective_identity_roles_required`	Unknown
`is_in_place_sharing_enabled`	Unknown
`is_on_prem_gateway_required`	Unknown
`is_refreshable`	Unknown
`name`	Unknown
`qna_embed_url`	Unknown
`query_scale_out_setting_auto_sync_read_only_replicas`	Unknown
`query_scale_out_setting_max_read_only_replicas`	Unknown
`target_storage_mode`	Unknown
`web_url`	Unknown

gateway

Column	Type	Keys
`id`	Unknown	PK
`annotation`	Unknown
`name`	Unknown
`public_key_exponent`	Unknown
`public_key_modulus`	Unknown
`status`	Unknown
`type`	Unknown

dataset_column

Column	Type	Keys
`dataset_id`	String	PK
`index`	Unknown	PK
`dataset_table_index`	Unknown	PKFK
`workspace_id`	String	PKFK
`data_type`	String
`description`	String
`format_string`	String
`is_hidden`	Boolean
`name`	String
`summarize_by`	String

dataset_measure

Column	Type	Keys
`dataset_id`	String	PK
`index`	Unknown	PK
`dataset_table_index`	Unknown	PKFK
`workspace_id`	String	PKFK
`description`	String
`expression`	String
`format_string`	String
`is_hidden`	Boolean
`name`	String

dataset_table_source

Column	Type	Keys
`dataset_id`	String	PK
`index`	Unknown	PK
`dataset_table_index`	Unknown	PKFK
`workspace_id`	String	PKFK
`expression`	String

dataset_table

Column	Type	Keys
`dataset_id`	String	PK
`index`	Unknown	PK
`workspace_id`	String	PKFK
`description`	String
`is_hidden`	Boolean
`name`	String

dataset_datasource

Column	Type	Keys
`dataset_id`	String	PK
`datasource_instance_id`	String	PKFK
`workspace_id`	String	PKFK

datasource_instances

Column	Type	Keys
`datasource_id`	String	PK
`gateway_id`	String	FK
`database`	String
`server`	String
`type`	String

report

Column	Type	Keys
`id`	Unknown	PK
`app_id`	Unknown	FK
`dataset_id`	Unknown	FK
`workspace_id`	Unknown	FK
`created_by`	Unknown
`created_date_time`	Unknown
`description`	Unknown
`embed_url`	Unknown
`is_ownedby_me`	Unknown
`modified_by`	Unknown
`modified_date_time`	Instant
`name`	Unknown
`original_report_id`	Unknown
`type`	Unknown
`web_url`	Unknown

report_user

Column	Type	Keys
`identifier`	String	PK
`report_id`	Unknown	PKFK
`display_name`	String
`email_address`	String
`graph_id`	String
`principal_type`	String
`profile`	Json
`report_user_access_right`	String
`user_type`	String