Power BI Premium Workspaces and Datasets

Piotr Kononow - Dataedo Team Piotr Kononow 27th October, 2021

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
0
There are no comments. Click here to write the first comment.