March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
A paginated report is opened in the Power BI website (app.powerbi.com). When I search for "Storm Lake", the search functionality correctly scrolls down to the 22nd row and highlights the match. This is shown in the picture below.
However, when the same report is modified to have a sticky header row (i.e. the header row always stays at the top; this is done by setting the "FixedData" property on the header row) and you search for "Storm Lake", it now takes you to the 23rd row (shown in the picture below). The highlighted match stays hidden behind the header row, and so the search functionality doesn't seem to be aware of the sticky header row.
The match is right behind the "Airport1" label.
I'd expect the search functionality to be aware of the sticky header and scroll down by the correct amount in that case.
If you compare the 2 screenshots side-by-side, I think you can see the problem clearly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @OasisPowerBI ,
Is your problem that the search function may not work as expected with sticky headers?
I've searched some of the documentation on this issue but haven't found a suitable explanation, can you provide details of the version so that we can reproduce the issue?
Best regards.
Community Support Team_Caitlyn