Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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...
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...
Thanks josef78, this is perfect! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
7 | |
2 | |
2 |