Documenting and cataloging Microsoft Fabric - Power BI
Due to an issue on Microsoft's side, PowerBI import does not return correct data. Until the issue is fixed or we find a workaround, please do not import changes from PowerBI environments.
We've just learned that Microsoft has turned off DMV querying in their API to PowerBI. According to According to Fabric Community this is not a permament change, but we don't have a timeframe on if and when it's going to be restored.
Since Dataedo uses DMV queries to gather metadata from PowerBI, until the issue is resolved, importing changes will not add any new objects, and instead will mark parts of your documentation as deleted. Please do not use this connector until further notice.
We're reaching to MS to get more details on the issue and separately looking for workarounds if it's not resolved in a timely manner.
Microsoft Fabric Power BI connector has all capabilities of our dedicated Power Bi connector. To get more insight read about our Power BI connecotor.
Prerequisities
How to Connect to Power Bi
Workspace access
To document the Power Bi workspace, you need to have at least Viewer access to the workspace. To verify it, simply open app.powerbi.com service, and see if the workspace to be documented is available to browse.
Documenting Dataset is available for Pro and Premium workspaces.
Connecting to Microsoft Fabric - Power BI
To connect to Power BI create new documentation by clicking Add documentation and choosing Database connection.
On the connection screen choose Power BI Reports and Datasets as DBMS
or choose Ms Fabric and MS Fabric -Power BI from dedicated panel.
Connection Details
- Workspaces - you can provide a workspace name by simply typing it or clicking Sign In button to log in to your Power Bi account and list available workspaces.
- Premium Workspace checkbox - check this box if you have any problem with importing your workspace (this is an alternative method of connecting to Power Bi), available when your workspace has premium capacity.
- XMLA Endpoint - if you have checked Premium Workspace, you will also see this box where you need to place the Endpoint. For instructions on how to get this value, see Connection Requirements.
- Document only report pages - in case of timeouts, you can check this box. Dataedo will document only reports' pages, which should help avoid timeouts during the import process.
After clicking the Sign In button to load workspaces you will need to authenticate and let Dataedo connect to your Power Bi Instance.
First, select the account on the Microsoft authentication screen:
Then, if it's your first use of Dataedo, you need to accept the license agreement and give the required permissions to Dataedo.
After accepting the agreement you will see a list of workspaces:
Select Workspace
Click Connect and go through the import process.