Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to 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
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!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.