List of all data sources in Power BI service

[HaiVN]

Helle community,

I would like to get list of all data sources for alle Power BI repports which were published in  several workspaces i Power BI service. How can I get it? 

Thank you! 

[v-menakakota]

Hi @HaiVN ,

Thank you @suparnababu8 , @freginier , @ArwaAldoud  for providing helpful solution.

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-menakakota]

Hi @HaiVN ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-menakakota]

Hi @HaiVN ,

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.

[ArwaAldoud · Accepted solution]

You can get a list of all data sources for Power BI reports published in multiple workspaces using the Power BI REST API.

You’ll need to
- Get all workspaces using the API:
https://learn.microsoft.com/en-us/rest/api/power-bi/groups/get-groups
- Retrieve all reports in each workspace:
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group
- Get data sources for each report:
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-datasources-in-group

This requires Power BI admin permissions and Azure AD authentication

If this response was helpful, please accept it as a solution and give kudos to support other community members

[freginier]

Hey there!

If you are an Admin on Power BI, you can see all the data sources. 

- Go to Power BI Admin Portal.
- Navigate to Tenant Settings → Data Sources.
- Here, you’ll see a list of all connected data sources.
- You can export the data for reference.

Hope this helps you!

Cheerio,

Zoe 😁😁

[suparnababu8]

Hi @HaiVN 

You can use use Power BI PowerShell cmdlets to get a list of data sources. Please go thorugh below accepted answer which was similar to your requirement. It might helps you.

https://community.fabric.microsoft.com/t5/Desktop/List-All-Data-Source-Database-Tables-Views-Used/td...

https://learn.microsoft.com/en-us/power-bi/connect-data/service-get-data

Thanks!