Forum Discussion

eslna's avatar
eslna
Icon for Advocate I rankAdvocate I
3 months ago
Solved

Search disabled in Paginated Report

Hello, We are currently migrating reports from SSRS to Fabric and encountered an issue in one report that we cannot figure out a solution for.  Issue: Search is greyed out for users with non...
  • trivedisunita's avatar
    3 months ago

    Hi eslna,

     

    This looks like a limitation in Fabric paginated reports rather than a permissions issue.

    The search box is only enabled when the rendered dataset is small enough for the client to index. In your case, when all parameter options are selected, the result set is large and the search control is disabled for non‑admin roles. Admins sometimes see different behavior because of caching or elevated privileges, but the underlying trigger is the volume of returned rows.

    That’s why search works fine when fewer parameter values are chosen, and why it only affects this one report out of 200.

    At present there’s no documented setting to override this — it’s tied to the rendering engine. If search is critical, you’ll need to reduce the dataset size (filtering, paging, or breaking the report into smaller slices). Otherwise, this is expected behavior until Microsoft updates the Fabric paginated report viewer.

     

    If this helped, a kudos would mean a lot! 

     

    Thank you 

     

    Sunita