Share via

SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab

RajeshKumar G 20 Reputation points
2026-05-15T10:15:41.8533333+00:00

ISSUE: After SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab after page refresh, even though the favorite is still saved in the Favorites tab. When users try to re add the favorite - they get error: "Something went wrong. Please try again later." INVESTIGATION FINDINGS: Database correctly saves/removes favorites UI doesn't refresh properly for linked reports only Re-adding fails due to UI/DB mismatch BaseReports work fine - only LinkedReports have issue From initial investigations on the database side it does not seem like a data corruption or duplicate issue during migration. SSRS PROD ENVIRONMENT is having a sql server 2022 CU 22 standard instance with reportserver db, 2 vm nodes with manual failover implemented through a .bat file triggered from jumpserver - starts & stops SSRS services on a schedule and updates keys table with correspondent failed over node. F5 load balancer for failover nodes pooling is also configured. Summary of source and destination SSRS environment: Source (where we migrated from) US-GR =  VM node1 =  VM node2 DB = ReportServerDB database instance version: Microsoft SQL Server 2016 (SP3) (KB5003279) - 13.0.6300.2 (X64)   Aug  7 2021 01:20:37   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) new current nodes (in use - this is where issue was reported): us-grr-sq0019 node1 node2 us-grr-DB (SQL Server 2022 CU22) NEW instance version & OS: Microsoft SQL Server 2022 (RTM-CU22) (KB5068450) - 16.0.4225.2 (X64)   Oct 22 2025 23:44:36   Copyright (C) 2022 Microsoft Corporation   Standard Edition (64-bit) on Windows Server 2022 Datacenter 10.0 <X64> (Build 20348: ) (Hypervisor) REQUEST: Please investigate if this is a known LinkedReport UI bug in SSRS 2022 and if there is a CU patch that resolves this. Note: we have the same version of SSRS on nonprod QA environment, any recommendation for changes will be tested there first.

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2026-05-15T10:16:00.25+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The provided information does not document any known SSRS 2022 bug or CU fix specifically related to favorites on linked reports disappearing from the Browse tab or UI/DB mismatches for favorites after migration.

    The context does show several SSRS 2016 issues that were fixed via cumulative updates (for example, problems with favorites in Power BI Mobile and session-related refresh issues), and in all those cases the documented resolution is to apply the relevant or latest cumulative update for the SQL Server/SSRS version in use. For example:

    • Favorites-related behavior in SQL Server 2016 Reporting Services was corrected in Cumulative Update 1 for SQL Server 2016.
    • Other SSRS behavior issues (such as automatic refresh errors) were also fixed via cumulative updates.

    However, there is no documentation here of an SSRS 2022-specific linked-report favorites UI bug or a CU that addresses the exact behavior described (favorites for linked reports disappearing from Browse while remaining in Favorites, and re-add attempts failing with a UI error despite correct database state).

    Based on the available information, the only supported, documented pattern is:

    1. Ensure the SSRS instance is on the latest cumulative update for its SQL Server version, because SSRS fixes (including UI and favorites issues) are delivered via CUs.
    2. If the issue persists on the latest CU and is not documented, open a support case with Microsoft to have the behavior investigated as a potential product bug.

    No additional, more specific fix for SSRS 2022 linked-report favorites is documented in the provided context.

    References:

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.