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

[PTFAL]

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?

[josef78 · Accepted solution]

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]

Thanks josef78, this is perfect! 🙂