# Microsoft Power BI schema ERD

Table and field reference for the Fivetran Microsoft Power BI connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| refresh_history_request_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| workspace_id | Unknown | FK |
| orders | Unknown |  |

### pipeline_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| 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 |
| --- | --- | --- |
| _fivetran_id | String | PK |
| app_id | Unknown | PK, FK |
| app_user_access_right | String |  |
| display_name | String |  |
| email_address | String |  |
| graph_id | String |  |
| identifier | String |  |
| principal_type | String |  |

### dataset_upstream

| Column | Type | Keys |
| --- | --- | --- |
| dataset_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| 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 | PK, FK |
| workspace_id | String | PK, FK |
| 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 | PK, FK |
| workspace_id | String | PK, FK |
| 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 | PK, FK |
| workspace_id | String | PK, FK |
| expression | String |  |

### dataset_table

| Column | Type | Keys |
| --- | --- | --- |
| dataset_id | String | PK |
| index | Unknown | PK |
| workspace_id | String | PK, FK |
| description | String |  |
| is_hidden | Boolean |  |
| name | String |  |

### dataset_datasource

| Column | Type | Keys |
| --- | --- | --- |
| dataset_id | String | PK |
| datasource_instance_id | String | PK, FK |
| workspace_id | String | PK, FK |

### 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 | PK, FK |
| display_name | String |  |
| email_address | String |  |
| graph_id | String |  |
| principal_type | String |  |
| profile | Json |  |
| report_user_access_right | String |  |
| user_type | String |  |

## Relationships

- refresh_schedule(dataset_id) → dataset(id)
- capacity_admin(capacity_id) → capacity(id)
- dataset_user(dataset_id) → dataset(id)
- dashboard_tile(report_id) → report(id)
- dashboard_tile(dataset_id) → dataset(id)
- dashboard_tile(dashboard_id) → dashboard(id)
- dashboard(app_id) → app(id)
- dashboard(workspace_id) → groups(workspace_id)
- dataflow_user(dataflow_id) → dataflow(id)
- app(workspace_id) → groups(workspace_id)
- refreshable_configured_by(refreshable_id) → refreshable(id)
- dashboard_user(dashboard_id) → dashboard(id)
- group_user(workspace_id) → groups(workspace_id)
- group_workbook(dataset_id) → dataset(id)
- group_workbook(workspace_id) → groups(workspace_id)
- groups(capacity_id) → capacity(id)
- groups(pipeline_id) → pipeline(id)
- refresh_history_attempt(refresh_history_dataset_id) → refresh_history(dataset_id)
- refresh_history_attempt(refresh_history_request_id) → refresh_history(request_id)
- refresh_history(dataset_id) → dataset(id)
- event_activity(capacity_id) → capacity(id)
- event_activity(report_id) → report(id)
- event_activity(workspace_id) → groups(workspace_id)
- event_activity(dataset_id) → dataset(id)
- pipeline_stage(workspace_id) → groups(workspace_id)
- pipeline_stage(pipeline_id) → pipeline(id)
- pipeline_user(pipeline_id) → pipeline(id)
- dataflow(workspace_id) → groups(workspace_id)
- app_user(app_id) → app(id)
- dataset_upstream(workspace_id) → groups(workspace_id)
- dataset_upstream(dataflow_id) → dataflow(id)
- dataset_upstream(dataset_id) → dataset(id)
- dataset(workspace_id) → groups(workspace_id)
- dataset_column(dataset_table_index) → dataset_table(index)
- dataset_column(workspace_id) → groups(workspace_id)
- dataset_measure(dataset_table_index) → dataset_table(index)
- dataset_measure(workspace_id) → groups(workspace_id)
- dataset_table_source(dataset_table_index) → dataset_table(index)
- dataset_table_source(workspace_id) → groups(workspace_id)
- dataset_table(workspace_id) → groups(workspace_id)
- dataset_datasource(datasource_instance_id) → datasource_instances(datasource_id)
- dataset_datasource(workspace_id) → groups(workspace_id)
- datasource_instances(gateway_id) → gateway(id)
- report(workspace_id) → groups(workspace_id)
- report(dataset_id) → dataset(id)
- report(app_id) → app(id)
- report_user(report_id) → report(id)