Following an upgrade KPI tiles have disappeared

The context provided does not specifically address issues related to KPI tiles disappearing after an upgrade from SQL Server 2019 to SQL Server 2022. However, it is not uncommon for certain features or configurations to be affected during an upgrade process. If you are experiencing this issue, it may be beneficial to check the following:

1. Compatibility Levels: Ensure that the compatibility level of your databases is set appropriately for SQL Server 2022.
2. Reporting Services Configuration: Verify that SQL Server Reporting Services (SSRS) is properly configured after the upgrade.
3. Permissions: Check if there are any permission issues that might prevent the KPI tiles from displaying.
4. Logs and Errors: Review any error logs or reports generated during the upgrade process for clues.

For specific troubleshooting steps or known issues, you may want to consult the SQL Server documentation or community forums for additional insights.

Hi Richardson Carolyn - Birkenhead-UK-ITSSO,

In addition to that you can follow these checks -

1.Confirm that the ReportServer database was upgraded using the SSRS Configuration Manager. Verify encryption keys were restored.

2.Validate KPI Items-In SSRS web portal, go to Manage > KPIs and check if they exist. If missing, check the ReportServer.dbo.Catalog table for KPI entries.

Hope this helps!