Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
ktjaysilver
New Member

Paginated Report using pbix dataset not refreshing

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?

2 REPLIES 2
ktjaysilver
New Member

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:

  • Manually refreshed the dataset and ran the Paginated report and the data is still showing old data although the dataset has been updated
  • I have rebuilt the paginated report from scratch and its still showing old data

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. 

Anonymous
Not applicable

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.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors