Connecting to Power BI Premium Workspaces and Datasets
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.
Prerequisites
License
To be able to connect to a dataset, the workspace needs to be premium licensed. It is indicated by a diamond icon next to the workspace name:
Enable XMLA Endpoint for Premium Per User license
-
In the Settings select Admin Portal > Premium Per User
-
Under dataset workload settings > XMLA Endpoint select Read only or Read and write
Enable XMLA Endpoint for Premium Capacity
-
In the Admin portal, select Capacity settings > Power BI Premium > capacity name.
-
Expand Workloads. In the XMLA Endpoint setting, select Read Write.
Add new connection
To connect to Power BI Workspace create new documentation by clicking Add documentation and choosing Database connection.
On the Add documentation screen choose Power BI Premium Workspace/Dataset:
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 authentication options:
-
Azure Active Directory - Password
-
Azure Active Directory - Integrated - this one uses Microsoft online authentication.
-
-
User - for Azure Active Directory - Password authentication.
-
Password - for Azure Active Directory - Password authentication.
-
Dataset - dataset name. You can select it by clicking [...] button.
How to get server name in Power BI Service
You can find the server name in workspace Settings > Premium > Workspace Connection.
How to authenticate to Power BI
You can select one of the following authentication options:
-
Windows Authentication uses the login you used to log in to Windows.
-
Azure Active Directory - Password you provide Azure AD username (e-mail address) and password.
-
Azure Active Directory - Integrated uses the Microsoft account assigned to the computer.
How to select dataset
Click [...] to expand the list of datasets, and choose one that matches the Power BI Dataset to document by Dataedo.
Perspective
In Power BI by default only one perspective Model is available and pre-selected after choosing the database.
Saving password
You can save the Azure Active Directory password for later connections by checking the Save password option. Passwords are saved in the repository database.
Importing metadata
When the connection is 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 the list of objects.
Confirm the list of objects to import by clicking Next.
The next screen allows you to change the default name of the documentation under which it will be visible in the Dataedo repository.
Click Import to start the import.
Outcome
Your database schema has been imported to new documentation in the repository.
