Skip to main content

Power BI

Needs Votes

Data Catalog integration in PowerBI Designer

Vote (860) Share
Ron Pooters's profile image

Ron Pooters on 20 Dec 2014 03:25:40

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

Administrator on 20 Aug 2020 01:24:05

Checking w/ the team where this is at.

Comments (65)
Ron Pooters's profile image Profile Picture

a70affb6 e1fe-46a5-b799-eb486627977f on 16 Aug 2020 03:58:54

RE: Data Catalog integration in PowerBI Designer

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.

Ron Pooters's profile image Profile Picture

db44e8bf 8b8a-4afe-b814-2f8f3e3442b7 on 16 Aug 2020 03:58:47

RE: Data Catalog integration in PowerBI Designer

Any news?

Ron Pooters's profile image Profile Picture

fcb25184 91ca-ea11-a812-000d3a8ddfb2 on 16 Aug 2020 03:58:38

RE: Data Catalog integration in PowerBI Designer

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.

Ron Pooters's profile image Profile Picture

5ab83948 7739-40b4-8907-1e9d6459a774 on 16 Aug 2020 03:58:35

RE: Data Catalog integration in PowerBI Designer

This is a big gap that every one of my customers asks for

Ron Pooters's profile image Profile Picture

e66af82b 97ca-ea11-a812-000d3a579c34 on 16 Aug 2020 03:58:29

RE: Data Catalog integration in PowerBI Designer

These appear to be two separate products. Be nice to get the additional meta data from Azure DC in Power BI.
See details here:
http://community.powerbi.com/t5/Desktop/Azure-Data-Catalog-Integration/td-p/562/page/2

Ron Pooters's profile image Profile Picture

193c923d 46c9-48f7-945d-45b50befced2 on 16 Aug 2020 03:58:28

RE: Data Catalog integration in PowerBI Designer

Integration between PowerBI and Azure Data Catalog is really important for both products in the long term. Can you please work with the ADC team to facilitate this very important feature

Ron Pooters's profile image Profile Picture

4671f9ba 4a1d-e811-8142-e0071b6aa0e1 on 16 Aug 2020 03:58:28

RE: Data Catalog integration in PowerBI Designer

Having an enterprise-wide list of all of the data sources used for reporting and analysis and making that list available to everyone using Power BI will help people discover, gain access to and understand data sources they may not have known existed, and in turn increase the value of the reports they create.

Consider using Azure Data Catalog, a cloud-based service for cataloguing all the data assets in your organization, to store your inventory of data sources.

Ron Pooters's profile image Profile Picture

b3604bd4 4f33-49e1-82ed-271326d0c9e0 on 16 Aug 2020 03:58:00

RE: Data Catalog integration in PowerBI Designer

'This is such a glaring gap with PBI. We need an easy way for PBI users to pick from an existing, curated, blessed list of:

- Data sources/connections, and,
- Queries/data sets

These should be shared objects so that if they're changed in one central place, all dashboards get updated.

Without this, everyone is recreating the wheel, and a "single version of the truth" is all but impossible.

Ron Pooters's profile image Profile Picture

9523443c 7707-452e-9862-7d8f73fbcc39 on 16 Aug 2020 03:57:00

RE: Data Catalog integration in PowerBI Designer

Can Power BI use Data Catalog, today?

Ron Pooters's profile image Profile Picture

c3cb1933 de2d-47f3-8aa0-d0a2821c5faf on 16 Aug 2020 03:55:39

RE: Data Catalog integration in PowerBI Designer

I would like to see the ability to publish queries as APIs to the Azure Data Catalog where they can be more completely documented and are searchable and usable to users of Power BI, Excel and other tools. I would also like to see an option for Power BI Server information (e.g. report/dashboard names, links to datasets, owners/users etc) to be automatically synchronised with Azure Data Catalog.