Connecting to Power BI Premium Workspaces and Datasets

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

This article explains how to connect Dataedo to Power BI workspaces and datasets and import metadata - tables & columns.

If you'd like to connect to Azure Analysis Services/SSAS Tabular, check this article.

Prerequisities

License

To be able to connect to dataset, workspace needs to be premium licensed. It is indicated by a diamon icon next to workspace name: Premium workspace

Enable XMLA Endpoint for Premium Per User license

  1. In the Settings select Admin Portal > Premium Per User
  2. Under dataset workload settings > XMLA Endpoint select Read only or Read and write

PPU XMLA perms

Enable XMLA Endpoint for Premium Capacity

  1. In the Admin portal, select Capacity settings > Power BI Premium > capacity name.
  2. Expand Workloads. In the XMLA Endpoint setting, select Read Write.

Capacity XMLA perms

Add new connection

To connect to Power BI Workspace create new documentation by clicking Add documentation and choosing Database connection.

Connection to Power BI Workspace

On the Add documentation screen choose Power BI Premium Workspce/Dataset:

Add docs PBI

Connection details

Provide connection details:

  • XMLA Endpoint - address of a XMLA endpoint e.g. powerbi://api.powerbi.com/v1.0/myorg/Sales
  • Authentication - choose one of the autethication options:
    • Azure Active Directory - Password
    • Azure Active Directory - Integrated - this one uses Mirosoft online authentication.
  • User - for Azure Active Directory - Password authentication.
  • Passowrd - for Azure Active Directory - Password authentication.
  • Dataset - dataset name. You can select it by clicking [...] button.

Power BI connection form

How to get server name in Power BI Service

You can find server name in workspace Settings > Premium > Workspace Connection.

Power BI server name

How to authenticate to Power BI

You can select one of following authentication options:

  • Windows Authentication uses login you used to log in to Windows.
  • Azure Active Directory - Password you provid Azure AD username (e-mail address) and password.
  • Azure Active Directory - Integrated uses Microsoft account assigned to computer.

How to select dataset

Click [...] to expand list of datasets, and choose one that matches Power BI Dataset to document by Dataedo.

Power BI list of databases

Perspective

In Power BI by default only one perspective Model is available and pre-selected after choosing database.

Saving password

You can save Azure Active Directory password for later connections by checking Save password option. Password are saved in the repository database.

Power BI filled connection form

Importing metadata

When connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use advanced filter to narrow down list of objects.

Power BI objects list

Confirm list of objects to import by clicking Next.

Next screen allows you to change default name of the documentation under which it will be visible in Dataedo repository.

Power BI documentation title

Click Import to start the import.

Power BI Import Progress

Outcome

Your database schema has been imported to new documentation in the repository.

Power BI documentation

Power BI support

Power BI support details

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.