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...
Data Management
Data Source
governance
Metadata
Report Server
  • ForcaTaico's avatar
    ForcaTaico
    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

ForcaTaico's avatar
ForcaTaico
Icon for Resolver II rankResolver II
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

franciscocohen's avatar
franciscocohen
Frequent Visitor
4 years ago

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