List of data sources

[HaiVN]

Hello community,

I have a problem where I would like to ask you! 

We have about  100 power BI reports which has been published i Power BI service. I would like to create a list of alle data sources  which our 100 reports use. Is that a method to list alle the data sources i my case? 

Thank you! 

[v-veshwara-msft]

Hi @HaiVN ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @HaiVN ,
Thanks for posting in Microsoft Fabric Community.

Just checking in to see if you query is resolved and if any responses were helpful. Otherwise, feel free to reach out for further assistance.

Thanks to @rohit1991 , @Shahid12523 for your responses and thanks @pallavi_r for sharing useful and similar links.

Thank you.

[pallavi_r]

Hi @HaiVN ,

In addition to what @Shahid12523  and @rohit1991 mentioned, sharing few links for references. 

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.reports/get-powerbireport?v...

https://learn.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/get-powerbidatasource?...

There's another community post discussing on this one.

https://community.fabric.microsoft.com/t5/Service/List-of-all-data-sources-in-Power-BI-service/m-p/4...

Thanks,

Pallavi

[Shahid12523]

Best method: Use the Power BI REST API to loop through all reports and extract their data sources programmatically.
Alternative options:
- Power BI Admin Portal (manual logs)
- External tools like Tabular Editor or Power BI Helper (if you have PBIX files)
- Fabric lineage view (if you're using Fabric)

[HaiVN]

@Shahid12523 

Thank you for your message! 
I can not find 'Power BI Admin Portal (manual logs)' from my user account. Can you show me where can i find it ? 

[v-veshwara-msft]

Hi @HaiVN ,

The Power BI Admin Portal is only available if your account has Service Admin rights. Just to clarify, there isn’t a section called manual logs in the portal. What it does provide are options such as:

1. Log Analytics (if connected): Using Azure Log Analytics in Power BI - Power BI | Microsoft Learn

2. Workspace monitoring : Workspace monitoring overview - Microsoft Fabric | Microsoft Learn

These help with monitoring usage and governance but do not give a direct export of all data sources. For your requirement of listing sources across many reports, the recommended approach is still the Power BI REST API or PowerShell (Get-PowerBIDataSource).

Have you had any progress in trying with the REST API?

Please reach out for further assistance.

Thank you.

[v-veshwara-msft]

Hi @HaiVN ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

[rohit1991 · Accepted solution]

Hi @HaiVN 

1. There is no built-in “export all data sources” button in the Power BI Service.

2. For a few datasets, you can check manually in dataset >> Settings >> Data source.

3. For many datasets (like your 100 reports), the only supported way is through the Power BI REST API or PowerShell (Get-PowerBIDataSource) that’s exactly what Microsoft documents.

4. If you are a Power BI admin, the Admin Portal shows gateway/cloud data sources, and Lineage view helps you see sources per workspace, but those are not bulk exports.