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

ffba8821 6569-4336-8450-33f87b2ac73c on 10 Sep 2020 14:02:04

RE: Data Catalog integration in PowerBI Designer

The capability for PowerBi Designer to gain access (data source) to the Data Catalog will make life for me and my company so much better. This is a feature that will be greatly appreciated and is urgently needed.
Thank you.

Ron Pooters's profile image Profile Picture

4bbb1923 babf-4c64-b8bf-3af9f5604539 on 16 Aug 2020 04:16:36

RE: Data Catalog integration in PowerBI Designer

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?

Ron Pooters's profile image Profile Picture

dbba2ef0 5730-4e1c-bb0b-4690f3940869 on 16 Aug 2020 04:15:48

RE: Data Catalog integration in PowerBI Designer

tick-tock - any news @CharlesSterling?

Ron Pooters's profile image Profile Picture

a9ddeafa e13b-453b-bb2b-dee6fa7bb2ac on 16 Aug 2020 04:15:35

RE: Data Catalog integration in PowerBI Designer

This is exactly the functionality we need to make our Data Warehouse easier to use for non IT users and new hires

Ron Pooters's profile image Profile Picture

7a9fbe97 4d8e-4c45-b433-889af5db0204 on 16 Aug 2020 04:14:28

RE: Data Catalog integration in PowerBI Designer

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 !

Ron Pooters's profile image Profile Picture

9f117463 ebaa-4d68-87fc-bfb213ca2808 on 16 Aug 2020 04:10:16

RE: Data Catalog integration in PowerBI Designer

Hello, is there any update on this idea?

Ron Pooters's profile image Profile Picture

f7f702e3 e320-4d52-805d-da737346f6fd on 16 Aug 2020 04:09:53

RE: Data Catalog integration in PowerBI Designer

We need this as well. Why is there no update??

Ron Pooters's profile image Profile Picture

c8408343 a6a0-40c4-b9f9-232c865e63a6 on 16 Aug 2020 04:09:53

RE: Data Catalog integration in PowerBI Designer

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:
https://feedback.azure.com/forums/906052-data-catalog/suggestions/36444655-power-bi-connector-get-data-via-azure-data-catal

Like other commenters I am very unhappy about the lack of integration between Azure Data Catalog and Power BI.

Ron Pooters's profile image Profile Picture

082225a2 58af-4e55-ac59-107ba23efeda on 16 Aug 2020 04:09:12

RE: Data Catalog integration in PowerBI Designer

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.

Ron Pooters's profile image Profile Picture

40502e40 76ce-4f42-b63d-31ddf675aac9 on 16 Aug 2020 04:06:49

RE: Data Catalog integration in PowerBI Designer

Here's the related Azure Data Catalog ticket:
https://feedback.azure.com/forums/906052-data-catalog/suggestions/31919092-power-bi-integration#comments

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"!