Power BI Premium Workspaces and Datasets

Applies to: Dataedo 23.x versions, Article available also for: 24.x (current), 10.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

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