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.
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.
Adam Harper commented
edited - actually looked up how many employees the companies had and reduced to the number that would actually utilize this feature.
Can I add 100k+ votes for my previous company, about 100k for their suppliers/customers and the same for my current company and ~50k more across my consulting clients?
Every one of these companies would vote for all of their employees to utilize this feature.
Rick Dry commented
This is a big gap that every one of my customers asks for
Brian Searle commented
These appear to be two separate products. Be nice to get the additional meta data from Azure DC in Power BI.
See details here: