Skip to main content
Microsoft Idea

Power BI

Needs Votes

Data Catalog integration in PowerBI Designer

Vote (968) Share
Ron Pooters's profile image

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 (71)
Ron Pooters's profile image Profile Picture

Robert Blitz on 16 Aug 2020 03:52:41

RE: Data Catalog integration in PowerBI Designer

Self-service BI isn't just about giving users access to tooling; they need access to data. If data remains silo'd, the whole idea of self-service BI will just wither on the vine.

Ron Pooters's profile image Profile Picture

Diego Bormann on 16 Aug 2020 03:52:35

RE: Data Catalog integration in PowerBI Designer

Funny, I was looking for this because I was triggered by the pricing page. It is mentioned as being part of the Pro version, but it is not there yet.
https://powerbi.microsoft.com/en-us/pricing/

Ron Pooters's profile image Profile Picture

David Zufic on 16 Aug 2020 03:52:23

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)

Ron Pooters's profile image Profile Picture

Ed H-B on 16 Aug 2020 03:52:22

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?

Ron Pooters's profile image Profile Picture

Neil on 16 Aug 2020 03:52:06

RE: Data Catalog integration in PowerBI Designer

Data Catalog search is an important part of Power Query

Ron Pooters's profile image Profile Picture

Brian.Mather on 16 Aug 2020 03:51:56

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.

Ron Pooters's profile image Profile Picture

DAvid on 16 Aug 2020 03:51:55

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”.

Ron Pooters's profile image Profile Picture

Etienne Oosthuysen on 16 Aug 2020 03:51:30

RE: Data Catalog integration in PowerBI Designer

I agree

Ron Pooters's profile image Profile Picture

jerome P on 16 Aug 2020 03:51:10

RE: Data Catalog integration in PowerBI Designer

when PowerBI, PowerQuery, Tabular and PowerBI Designer will support Azure Data Catalog site?

Ron Pooters's profile image Profile Picture

Mike Honey on 16 Aug 2020 03:51:04

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.