Forum Discussion

PTFAL's avatar
PTFAL
New Member
5 years ago
Solved

List Power BI Report Server dashboards dependent on a specific data source

I'm involved in decommissioning an SQL database that has been used as a data source for Power BI dashboards on a on-prem Power BI Report Server. Is there an SQL query I can run on the ReportServer database to list all dashboards that are using this database?

  • Most easy way is use Odata conector to connect Power BI  Report server API itselft on .../reports/api/v2.0/ you can easy list and search all connection including connection strings...

     

    Next option is also use powershell commands...

2 Replies

  • josef78's avatar
    josef78
    Memorable Member

    Most easy way is use Odata conector to connect Power BI  Report server API itselft on .../reports/api/v2.0/ you can easy list and search all connection including connection strings...

     

    Next option is also use powershell commands...

    • PTFAL's avatar
      PTFAL
      New Member

      Thanks josef78, this is perfect! 🙂