Data Catalog integration in PowerBI Designer
The PowerBI Designer is missing integration with the Data Catalog and there is no online search functionality. The data catalog is a core component of the reporting solution so let me use it with the Power BI Designer
Checking w/ the team where this is at.
If Power BI is REALLY envisioned as an Enterprise BI (especially Self-BI) Tool this feature is a MUST, i.e. there has to be a way to create & maintain a centralized Data Catalog and be able to discover, consume the data but also the semantic information/description of the entities & attributes.
Best way would probably be via Dataflows (which are strongly recommended by Microsoft for centralized data ingestion and “ETL”) and if done this way we could leverage on the Azure DataLake Gen2/CDM functionality?
Is there any answer or roadmap from Microsoft available yet?
Daragh Fitzpatrick commented
tick-tock - any news @CharlesSterling?
This is exactly the functionality we need to make our Data Warehouse easier to use for non IT users and new hires
simon opper commented
I've come from other tools that put metadata management at the forefront of their enterprise value proposition ( RDF, linked data, master data management)..... the fact that this issue is 4 years old with no response shows to the me that MS is more interested in sales of products than addressing the costs that it's products create through lacking data governance ! It espouses to be an enterrpise tool to unleash data..... when in fact it enforces a set of disconnected workflows which are almost ensured to create chaos in data when data is exposed to SME consumers through Power BI.
This feature combined with the ability to ingest, register, orchestrate, migrate, proppigate and administer metadata about models, schema, data transformations and apply controlled bussiness glossaries and taxonomies are the minimum for good governance. Come on MS !
Hello, is there any update on this idea?
Jeroen Habets commented
Will this idea cover my urgent need to be able to use Azure Data Catalog to discover and connect to (objects in) sources.
I couldn't find this specific use case in the Azure Data Catalog ideas so logged a new idea:
Like other commenters I am very unhappy about the lack of integration between Azure Data Catalog and Power BI.
Lynn Gregory commented
We need this as well. Why is there no update??
Now that this idea is about to celebrate its 4th birthday, an official response is long overdue. What are the reasons for delay? Does MS have required priorities that must be met before the AZURE Data Catalog and PowerBI Desktop are allowed to talk with one another? Was painting the filter blade white truly more important? There are more than 500 very confused customers that would appreciate an explanation. Love what you're doing. Just eager to understand. Please. Thank you.
Olivier Travers commented
Here's the related Azure Data Catalog ticket:
It's bizarre that this has still not been done in PBI Desktop when browsing the Data Catalog in Excel shows a dialog box dubbed "Power BI"!
Kell Aurisch commented
Can you please let me know if we have a resolution on this? Currently just copy and paste from the Advance editor is the quickest option but being able to share the queries with others in the company would be more than "handy". Cheers
Any official Microsoft response to this? Is it on your Roadmap? If yes, is there an ETA? Thanks!
Ed H-B commented
I just came back to this same issue after posting an initial comment 2 years ago to find that a user friendly solution to this fundamental daftness still hasn't been implemented by Microsoft. So we're off to find another non-MS product that will deliver, which is a shame as PQ and PBI are both good products (independently of themselves!)
Marwan Jubran commented
PBI should support consuming queries from data catalog, the underlying M language source code is identical!
Adam Harper commented
Hi Chuck - any updates on where the team is with this?
Patrick Sura commented
@Fred Kaffenberger That works, wow! But quite complicated and not the preferred way for standard users.
Fred Kaffenberger commented
To use a shared query in Power BI currently, you have to open Excel, Data tab on the ribbon, Get Data, Data Catalog Search, Load a Query (likely connection only); edit the workbook query, pop out the query list, right click, copy. Then go to Power BI, edit queries, and paste. Then, repeat every time you want to use a shared query.
Jim Santiago commented
In order to completely deportment Power BI and enable users to be self-service having a data Catalog is a must.
Can we have an update please? This feature is desperately needed.
We are being asked for this functionality almost every time we demo models. This is definitely necessary to improve Power BI's positioning as an industry leader in Business Intelligence.