Power BI Premium Workspaces and Datasets

Applies to: Dataedo 23.x (current) versions, Article available also for: 10.x

Power BI Premium allows you to connect to workspaces and datasets with XMLA endpoint. XMLA is the same communication protocol used by the Microsoft Analysis Services engine, and Dataedo uses the same connector as the Analysis Services Tabular.

Prerequisites

In order to enable XMLA endpoint your workspace has to be in Premium mode (either Premium per capacity or Premium per user) or in Embedded mode.

Supported metadata

  • Tables
    • Physical tables
    • Calculated tables
    • Virtual tables
  • Columns
    • Name
    • Data Type with length
    • Nullable
    • Formula (for Measures and Computed columns)
  • Relations
    • Table names
    • Column names
    • Cardinality

Data profiling

Datedo does not support data profiling in PowerBI.

Limitations

Following datasets won't be documented by Dataedo (XMLA Endpoint limitation):

  • Datasets based on a live connection to an Azure Analysis Services or SQL Server Analysis Services model.
  • Datasets based on a live connection to a Power BI dataset in another workspace.
  • Datasets with Push data by using the REST API.
  • Excel workbook datasets.

Learn more

Connect to Power BI Premium workspaces and datasets

Found issue with this article? Comment below
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.