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.