Forum Discussion

shanecwu's avatar
shanecwu
Icon for Helper I rankHelper I
5 years ago
Solved

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...
  • ForcaTaico's avatar
    5 years ago

    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