Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a paginated report which gets rendered successfully. On using the page navigation as shown in the screenshot below highlighted in yellow, it is actually making a call to database and then again taking a long time to load the second page. This is occuring on every page navigation.
What could be causing this behaviour? I believe once the report is loaded, navigating through pages should not make any calls to database as there are no changes being made to parameters and only changing the pages.
Any help on this would be highly appreciated.
Hi @saif
Paginated reports work differently to Power BI Datasets.
What you are viewing is 100% how it works. It only queries the data required for each single page. When you click to go to the next page, it then runs another query to get the data for the page. This is by design
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
41 | |
26 | |
24 | |
20 | |
18 |
User | Count |
---|---|
54 | |
42 | |
24 | |
21 | |
20 |