Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
shanecwu
Helper I
Helper I

List all Data Sources in all published PBIX files

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

1 ACCEPTED SOLUTION
ForcaTaico
Resolver II
Resolver II

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

View solution in original post

4 REPLIES 4
ForcaTaico
Resolver II
Resolver II

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

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

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

This will do very nicely, thank you!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.