Forum Discussion
Paginated Report using pbix dataset not refreshing
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.