Power BI Datasets (legacy)

deprecated connector

The Power BI Datasets connector is no longer maintained or developed.

To document your Power BI content, please use the Power BI Reports and Datasets connector instead.

Power BI Datasets 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 the 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

Dataedo does not support data profiling in PowerBI.

Limitations

The 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