Tenant Wide Data Source Type Report

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,