Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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! 🙂