Tenant Wide Data Source Type Report

[worldpay-unr]

I am looking how to holistically see what type of data connections are being used in the Power BI tenant. 

So I would want to know how many SharePoint Online connections, SQL and Snowflake. I remember seeing something a very long time ago and alas, that report is non-existent. 

Any tips? 

[v-veshwara-msft]

Hi @worldpay-unr ,

Just following up again regarding your issue. If your problem has been resolved, please mark the helpful reply as the Accepted Solution to assist others in the community.

If you still need assistance, feel free to reach out.
Thank you.

[v-veshwara-msft]

Hi @worldpay-unr ,

We haven’t heard from you since our last response and wanted to check if the provided solutions met your needs. If they did, please consider accepting the solution to help others benefit. Otherwise, feel free to reach out for further assistance.

Thank you!

[v-veshwara-msft]

Hi @worldpay-unr ,

We haven’t heard from you since our last response and wanted to check if the provided solutions met your needs. If they did, please consider accepting the solution to help others benefit. Otherwise, feel free to reach out for further assistance.

Thank you!

[v-veshwara-msft]

Hi @worldpay-unr ,

Thank you for reaching out with your query about monitoring data connections across your Power BI tenant. @ibarrau  has shared a great approach using the Power BI REST API to list datasets and their associated data sources.

To further enhance your monitoring capabilities, I’d like to highlight an additional method:
Power BI Scanner API:

The Power BI Scanner API enables administrators to retrieve detailed metadata across the entire tenant, including datasets, reports, dashboards, and data sources. This provides a comprehensive overview of all data connections within your environment.

For more details, please refer to: Metadata scanning overview - Microsoft Fabric | Microsoft Learn.
Hope this helps.
Please mark the helpful reply as solution to assist others with similar queries. Feel free to reach out for further assistance.
Thank you.

[ibarrau · Accepted solution]

Hi. As Fabric Administrator, you could open the settings pane (top right corner) and click at "Manage connections and gateways". There you should see all the connections built at the whole tenant. If the list is too long, you should consider building a script to the API.

Using the Power Bi Rest API as admin. You could get all datasets ids from the tenant. Use: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin

Then iterate the list requesting: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasources-as-admin

That way you could get all the sources at the tenant from Power Bi semantic models. If you want to do it with dataflows, you should do the same, get them and iterate (check the proper request at https://learn.microsoft.com/en-us/rest/api/power-bi/

I hope that helps,