View All Data Sources for all Datasets published to Power BI Service

[Anonymous]

Hello,

I'm curious if there is a way to do this-

I'm the PBI admin for my organization and want to be able to see which tables and sources are being used across all published objects (without having to go through all 200+ workspaces manually, downloading .pbix, and researching file paths or source connection info).

Ideally there would be a way to pull this data in to see which sources are being used the most, and even more beneficial, which tables from those sources are being used.

Ultimately I'm hoping to identify which teams are using the same data and look into building something like a dataflow that can be refreshed once that multiple teams can use, instead of pulling the same data multiple time from a raw data source.

[Anonymous]

You can see the solution that might help you to get list of all data source and respective users on all those data sources on following article
Solved: Extract gateway connections details - Data source ... - Microsoft Fabric Community

[collinq]

Hi @Anonymous ,

Yo ucan retrieve this information using the API functionality along with Power BI.  That information can be found here:

Power BI REST APIs - Power BI REST API | Microsoft Docs

And, specifically, I think you are looking for this one here:  Admin - Datasets GetDatasetsAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

[Anonymous]

Thank you @collinq !

The one issue I see with this route is that it gives me the name of the table based on how the user pulled it into their .pbix.

For a crude example:

My source table is called AllCustomers

Dataset1 pulls it into .pbix and names it "CustomerTable"

Dataset2 pulls it into .pbix and names it "My Customers"

Using the API I won't be able to identify that 2 users are pulling from the same AllCustomers table (since it will show as 2 different tables)

[collinq]

Hey @Anonymous ,

Hmmmmm, well, maybe this one then - that gives the datasource and not just the name?

Admin - Datasets GetDatasourcesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs