Does Spotlight on SQL Server Enterprise support Power BI Reporting Service?
Microsoft has announced that starting with SQL Server 2025, Power BI Report Server (PBIRS) will replace the standalone SSRS installer as the default on‑premises reporting solution. Spotlight Enterprise currently provides reporting functionality based on SSRS.
In version 15.2 we have introduced a new Power BI Reporting Service alarm, with support of PBIRS in the Services drilldown dashboard. Please see details below:
Services - Power BI Reporting Service alarm:
This alarm becomes active when this Power BI Reporting service is installed but not active.
Services currently monitored are:
When this alarm is current:
Check the SQL Server | Support Services drilldown | Service Status page to see the status of all known Power BI Reporting services.
Review messages in the SQL Server | Error Log drilldown to determine the reason the service is not running.
Restart the affected service if necessary.
Right click the service in the SQL Server | Support Services drilldown | Service Status page | Service Status grid