List all Data Sources in all published PBIX files

[shanecwu]

Hi folks,

I'm looking for a way to list all data sources used in all Power BI reports on the Report Server.  So far I have not been successful, and I've even looked at the report server tables.

Has anyone done this or have ideas?  Looking for a native solution, not 3rd party tools, and I would prefer to not have to implement yet another process just to capture this information.

Thanks, Shane

[ForcaTaico · Accepted solution]

Hi,

One option is to use the 'OData feed' connection in Power Query.

http://[reportserverurl]/reports/api/v2.0/

Select the tabel "PowerBIReports" then you can expand the column "DataSources" which has the information about the connection.

Regards Taico

[franciscocohen]

Hi,

I'm using power bi service. Is this solution only applicable to power bi server?

What should be the url address for my Odata feed?

Thank you

[ForcaTaico]

Hi @franciscocohen 

The above URL is for the the on-prem version (Power BI Report Server).

I do not use the service myself - but maybe this https://api.powerbi.com/v1.0/myorg/reports

See more here: Reports - Get Reports - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Regards Taico

[shanecwu]

This will do very nicely, thank you!