Power BI is a business analytics tool developed by Microsoft that allows users to visualize data, share insights, and make data-driven decisions through interactive reports and dashboards. It integrates with various data sources, providing robust data analysis and sharing capabilities for individuals and organizations.
Default hierarchy
In the chart below, you will find the organizational structure of Power BI objects. Objects are in represented in green and folders are in yellow.
Object types
Dawiso ingests the following objects from Power BI:
Application
Maps to Power BI Application object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| ApplicationId | Id |
| Description | Scanned Description |
| PublishedBy | Published By |
| LastUpdate | Last Update |
Datasource
Maps to Power BI Datasource object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| GatewayId | Id |
| Type | Created |
User
Maps to Power BI User object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| WorkspaceId | Id |
| Description | Scanned Description |
| Type | Type |
| State | State |
| IsOnDedicatedCapacity | Is On Dedicated Capacity |
| CapacityId | Capacity Id |
| DataRetrievalState | Data Retrieval State |
| DefaultDatasetStorageFormat | Dataset Storage Format |
Dashboard
Maps to Power BI Dashboard object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| DashboardTileId | Id |
| SubTitle | Scanned Description |
| ReportId | Report Id |
| DatasetId | Dataset Id |
| DatasetWorkspaceId | Dataset Workspace Id |
Dataflow
Maps to Power BI Dataflow object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| DatamartId | Id |
| Description | Scanned Description |
| ConfiguredById | Configured By Id |
| ConfiguredBy | Configured By |
| ModifiedById | Modified By Id |
| ModifiedBy | Modified By |
| ModifiedDateTime | Modified |
| State | State |
| Status | Status |
| Type | Type |
| SuspendedBatchId | Suspended Batch Id |
| Datasources | Datasources |
| EndorsementDetails | Endorsement Details |
| Endorsement | Endorsement |
| CertifiedBy | Certified By |
| SensitivityLabel | Sensitivity Label |
| UpstreamDataflows | Upstream Dataflows |
| UpstreamDatamarts | Upstream Datamarts |
Dataset
Maps to Power BI Dataset object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| Description | Scanned Description |
| IsHidden | Hidden |
| Source_Expression | Source Expression |
| Rows | Rows |
Dataset Table Column
Maps to Power BI Dataset Table Column object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| Description | Scanned Description |
| IsHidden | Hidden |
| DataType | Data Type |
| Expression | Expression |
| DataCategory | Data Category |
| FormatString | Format String |
| SortByColumn | Sort By Column |
| SummarizeBy | Summarize By |
Dataset Table Measure
Maps to Power BI Dataset Table Measure object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| Description | Scanned Description |
| IsHidden | Hidden |
| Expression | Expression |
| FormatString | Format String |
Report
Maps to Power BI Report object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| ReportId | Id |
| Description | Scanned Description |
| DatasetId | Dataset Id |
| ApplicationId | Application Id |
| OriginalObjectId | Origina lObject Id |
| CreatedById | Created By Id |
| CreatedBy | Created By |
| CreatedDateTime | Created |
| ModifiedById | Modified By Id |
| ModifiedDateTime | Modified |
| ModifiedBy | Modified By |
| WebUrl | Web Url |
| EmbedUrl | Embed Url |
| ReportType | Report Type |
| EndorsementDetails | Endorsement Details |
| Endorsement | Endorsement |
| CertifiedBy | Certified By |
| SensitivityLabel | Sensitivity Label |
| DatasourceUsages | Datasource Usages |
Report Page
Maps to Power BI Report Page object type.
| Source Attribute | Target Attribute in Dawiso |
|---|---|
| Name | Name |
| DisplayName | Display Name |
| Order | Order |
Relations
| From Object Type | Relation Type | To Object Type | Note |
|---|---|---|---|
| Application | is publishing / published by | Report | Report is published via an Application. |
| Report | has datasource / datasource | Dataset | Report has Dataset as a data source. |
| Dataset | has datasource / datasource | Datasource | Dataset reads data from Datasource. |
| Datasource | has datasource / datasource | Gateway | Datasource reads data via Gateway. |
| Report | used in / used by | Dashboard Tile | Report visual is published to a Dashboard Tile. |
| Dataset | used in / used by | Dashboard Tile | Report visual pinned to Dashboard Tile reads data from this Dataset. |
| Report | used in / used by | Dashboard | Report visual is pinned to a Dashboard. |
| Dataset | used in / used by | Dashboard | Daset is referenced by pinned visuals in the Dashboard. |
| Datamart | has datasource / datasource | Datasource | Datamart reads data from Datasource. |
| Dataflow | has datasource / datasource | Datasource | Dataflow reads data from Datasource. |
Relations diagram
