topic Re: List all Data Sources in all published PBIX files in Report Server

List all Data Sources in all published PBIX files

shanecwu — Wed, 09 Dec 2020 16:56:51 GMT

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

Re: List all Data Sources in all published PBIX files

ForcaTaico — Thu, 10 Dec 2020 06:51:38 GMT

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

Re: List all Data Sources in all published PBIX files

shanecwu — Sat, 12 Dec 2020 05:17:47 GMT

This will do very nicely, thank you!

Re: List all Data Sources in all published PBIX files

franciscocohen — Tue, 26 Apr 2022 14:17:10 GMT

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

Re: List all Data Sources in all published PBIX files

ForcaTaico — Mon, 02 May 2022 10:04:07 GMT

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