Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have built a paginated report that uses a pbix dataset to pull in data. I have set the pbix dataset up to refresh and the corresponding Power BI report is reflecting the correct data. When I go to the Paginated Report that uses that same dataset the data is not showing all of the data. The data stops at a certain point and won't refresh at all. The Power BI dataset is set up on a refresh schedule and I've also manually refreshed the dataset, I've tried recreating the paginated report and it always pulls up that same data without the newer information that exists in the Power BI dataset. What can I do to correct or resolve this issue? I know that paginated reports are created at the rendering time and do not have refresh times or anything like that. I'm wondering won't it pull the new and updated data that exists in the Power BI dataset that its referencing and how can I fix it?
My Power BI dataset is refreshing as intended. I have checked the refresh history and there are no failures. I have also checked the Power BI report that is connected to that same underlying dataset and it has refreshed data as well. The only issue is the Paginated Report is not showing the refreshed data. This paginated report does not use parameters. I built the DAX in Power BI Desktop and copied the table query and pasted it into the Paginated Report to mimic the Power BI Desktop report so no parameters are being used in the Paginated Report. I also removed the statement from the DAX that "windowed" statement that limits the results to 501 rows so that is shows the full result set.
The paginated report is not appearing blank, the report is showing old data and won't refresh with the new updated data that is contained in the Power BI dataset that it uses. It returns results when ran it just is returning old results and won't show the updated data.
I have done the following:
It appears that the data is being cached and the cach isn't being cleared or something because the underlying dataset is showing the correct information and is being refreshed and has not failed during refresh. The Power BI Report that is using the dataset is working correctly and showing the correct data. The Paginated Report is the only thing that isn't updated and showing old data. Its pulling and displaying data its just not the updated data that is contained in the underlying Power BI dataset.
I have also verified that I'm using the latest version of Power BI Report Builder as well.
Hi @ktjaysilver ,
Now please look at the underlying dataset to make sure that it is being refreshed and then your paginated report is being run.
When report designers create a paginated report, they're really creating a report definition. It doesn't contain the data. It specifies where to get the data, which data to get, and how to display the data. When you run the report, the report processor takes the report definition, retrieves the data, and combines it with the report layout to generate the report. Sometimes, the report displays default data. Other times you need to enter parameters before the report can display any data.
Select a paginated report to open it in the Power BI service. If it has parameters, you need to select them before you can view the report.
A paginated report can appear blank until you select parameters and choose View report.
More details: Paginated reports in the Power BI service - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.