Forum Discussion
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
- josef78Memorable 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...
- PTFALNew Member
Thanks josef78, this is perfect! 🙂