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

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

PTFAL — Thu, 18 Feb 2021 22:25:23 GMT

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?

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

josef78 — Sat, 20 Feb 2021 17:29:47 GMT

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...

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

PTFAL — Sun, 21 Feb 2021 21:39:06 GMT

Thanks josef78, this is perfect! 🙂