Ron Pooters on 20 Dec 2014 03:25:40
The Power BI Desktopis 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
Administrator on 20 Aug 2020 01:24:05
Checking w/ the team where this is at.
- Comments (69)
RE: Data Catalog integration in PowerBI Designer
You need to think broader in your solutioning, most organisations have large investments in data catalogue products not Microsoft enabling your solution to integrate with the key players as a minimum in this space is more a customer value delivery. (ie IBM Glossary etc)
RE: Data Catalog integration in PowerBI Designer
All of these great tools are redundant to us as a user orientated reporting solution until the Data Catalogue is also available in Power BI.
We can't see the the point of all this effort (albeit in the right direction) if the fundamental relationship between the apps isn't there.
Moreover, why is the Power Query tab in Excel labelled 'Power BI' if you can't actually share the data sources in the data catalogue with the Power BI apps?
RE: Data Catalog integration in PowerBI Designer
Data Catalog search is an important part of Power Query
RE: Data Catalog integration in PowerBI Designer
Great to see this is planned. Sharing Functions and queries will save time and drive consistency. Best if it is available in both Excel and Power BI Desktop tools. Keep up the good work.
RE: Data Catalog integration in PowerBI Designer
The ability to access our existing Power Query (PQ) queries which we built in Excel and uploaded to our Data Catalog Query or even our recent data sources in Excel to make them also accessible in Power BI desktop (PBI) and preferably synced across MS Power BI applications.(at least between excel & PBI).
Importing the excel file is great 1st time round but it is not the solution as any future PQ amendments in the source excel file cannot currently be "updated" in the PBI file.
A new import of the updated excel file with amended queries generates a new .pbix and loses all previous development of datamodel & reports.
The Power Query data source “Data Catalog” is a great function for also sharing queries across the organisation and thus a Power BI developer team. Even some source control of queries would be helpful.
If you too think this feature would help Power BI then please click the VOTE button on the left now. Thanks together we can “Have the Power BI”.
RE: Data Catalog integration in PowerBI Designer
I agree
RE: Data Catalog integration in PowerBI Designer
when PowerBI, PowerQuery, Tabular and PowerBI Designer will support Azure Data Catalog site?
RE: Data Catalog integration in PowerBI Designer
I agree with Anonymous (Jan 29)- the low vote for this is disappointing (currently 74 vs 750). Hopefully this feature can be reinstated soon - I have no interest in the new PowerBI until this is available.
RE: Data Catalog integration in PowerBI Designer
Since you are integrating Power Query in the PowerBI Designer, all features from the Excel version, including the Data Catalog, should be ported over. Unless of course the intention is to have PowerView parity between Excel and the Designer and you are planning on keeping the PowerQuery advanced features exclusive to Excel in order to differentiate the products; what should not happen though is that Excel gets fewer features than PowerBI Designer. A clear statement on what the future of Excel PowerQuery / PowerView is vis a vis the PowerBI Designer would probably help a lot in clearing up the confusion around these two tools.
RE: Data Catalog integration in PowerBI Designer
It has to. The data catalog is the glue hat can bind an *enterprise* BI strategy together. What's the point if your flagship BI tool doesn't know what it is? It's demoralising to see something like this scratching around on 40 something votes whilst the ability to write custom DAX is polling 250 (which is more than the total number of people worldwide that have bothered to learn DAX).