Power BI Connector - Get Data via Azure Data Catalog
I would like Azure Data Catalog to be a special Power BI Connector that supports the following scenario:
In Power BI Desktop I click "Get Data"
Select "Azure Data Catalog"
Select one or more objects from the data catalog
A connection is made to the source(s) of the selected object(s)
NOTE: This is a different feature from making Power BI data available in the catalog and catalog data available for reporting:
NOTE: This is a different feature from making the catalog data available for reporting:
Most of our reporting will be done using PowerBI reports. The lack of a way to show catalog info for a Tabular Model in its corresponding PowerBI report is discouraging lot of users.
Agree, we need an easy way to integrate with Power BI to build visual linages for registered assets to help consumers understand relationships from Data lake, EDW tables to views to Analysis Services models.
Jeroen H commented
The main driver is to allow easy user-friendly discoverable access to items catalogued in the Data Catalog for end users.
Your work around requires intensive M programming and therefore more complex than manually navigating the Data Catalog and then in Get Data manually navigating to discovered items.
NOTE: That lack of this feature including manually having to check relations is the main impediment raised by our business users (as they are used to it in tools like Business Objects)
Hi @Jeroen H,
your request could be handled via the Data Catalog API https://docs.microsoft.com/en-us/rest/api/datacatalog/.
Start with a blank query and then go to "extended editor" and add the power query M-Code including the web url of the api, like described in the docu.