List every dashboard and data sources in a workspace

[BlackBird]

Hey guys, I have a task to list the data sources from all reports published in some workspaces (about 60 reports). The first thing I could think, and sure the most obvious, is to download each pbix, open and look at the data sources but this is very tedious and will require a lot of time. I was wondering if there is a way to automate this. In my search I found this post List all Data Sources in all published PBIX files but the solution there is for the report server. I tried the rest api mentioned but couldn't make it work, afaik a non-public api will need a token, right? I don't have one and couldn’t connect with oAuth.  I tried messing with dax studio and tabular editor but found nothing there. Next, I try to open the pbix as a zip and see what I can find there, but I was wondering, any of you guys had to do this in the past? How would you approach this?

[GilbertQ · Accepted solution]

Hi @BlackBird 

By far the easiest way to do this is to use the scanner API data, which will allow you to get all the dashboards that reports the data sources and even the underlying queries within the power query. Here is a link to get you started.

Here is an option to use Power Automate: Using the Power BI Scanner API to Manage Tenant’s Entire Metadata – PowerBI.tips

And here is an option to use a Fabric Notebook: Downloading Scanner API data using a Microsoft Fabric Notebook - FourMoo | Microsoft Fabric | Power ...

[v-nmadadi-msft]

Hi @BlackBird ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks and regards

[v-nmadadi-msft]

Hi @BlackBird,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-nmadadi-msft]

Hi @BlackBird,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi  @BlackBird,
Thanks for reaching out to the Microsoft fabric community forum.

Thank you to @GilbertQ  for their valuable points, scanner api can be explored to check if we can get the data sources from power BI reports.

But other possible methods to get your desired result is using REST API and Semantic model connectivity using XMLA endpoint
Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...
which as you mentioned you have already tried then it is advisable to try and find the root cause of where exactly it is going wrong and try to fix the error, as these methods are commonly used ones and these are best methods to get your desired results.

Ensure that the XMLA Endpoint is enabled for the workspace containing your dataset. To do this, go to the Power BI Service and navigate to the appropriate workspace. Then, click on Workspace settings and go to the Premium settings section. Make sure the workspace is assigned to a Premium capacity (either dedicated or Premium Per User). Finally, verify that the XMLA Endpoint is available and enabled, as this is required to connect via Tabular Editor or DAX studio.

Reference article for REST API: Reports - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[GilbertQ · Accepted solution]

Hi @BlackBird 

By far the easiest way to do this is to use the scanner API data, which will allow you to get all the dashboards that reports the data sources and even the underlying queries within the power query. Here is a link to get you started.

Here is an option to use Power Automate: Using the Power BI Scanner API to Manage Tenant’s Entire Metadata – PowerBI.tips

And here is an option to use a Fabric Notebook: Downloading Scanner API data using a Microsoft Fabric Notebook - FourMoo | Microsoft Fabric | Power ...