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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Alienvolm
Helper IV
Helper IV

Dataset refreshes but Report and Paginated report don't

Hello, 

 

I have a dataset connected to a Data Gateway that refreshes every day at 3.30PM. The dataset serves a report and two Paginated reports, as follows:

 

Alienvolm_0-1624394731503.png

Lately, the users of the reports have detected discrepancies in the information, and it looks like they are due to the fact that the Paginated reports and the Report are not refreshing for days at a time. 

 

I haven't received any failure notifications from the gateway, and the refresh histopry indicates that dataset is refreshing as it's supposed to:

Alienvolm_2-1624395124512.png

 

However, I had to manually refresh the report in Power BI desktop and replace the dataset manually to get updfated results for the report. 

 

Also, in the List view from the Power BI Service, I don't see the refreshes for the paginated reports (I suppose I should see them here?):

 

Alienvolm_1-1624395010947.png

Any idea how to fix this? 

 

Thanks! 

 

~Alienvolm

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Alienvolm 

 

THe reason for now refresh for paginated reports is because it only runs and displays data when it is run. There is no caching that is stored for paginated reports.

 

I would look at the underlying dataset to make sure that it is being refreshed and then your paginated report is being run?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @Alienvolm 

 

THe reason for now refresh for paginated reports is because it only runs and displays data when it is run. There is no caching that is stored for paginated reports.

 

I would look at the underlying dataset to make sure that it is being refreshed and then your paginated report is being run?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ,

 

Sorry for the late answer... In the end it was an error in the flow that generates the report. It seems to be working fine now! 

 

Thanks! 

 

~Alienvolm

Thanks for letting us know.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @Alienvolm 

 

Can you please make sure that you click on the Reset to Default once the datasets have updated?

 

Also once the dataset has updated, what happens if you create a new report off the dataset can you see the updated data?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ

 

When I refresh the report manually the Reset to Default button is always greyed out:

Alienvolm_0-1624475531482.png

Also, I have created a new report for testing and the refresh date shows when I last manually refreshed the dataset:

Alienvolm_1-1624475860048.png

As you can see, the two paginated reports don't show any date. Is that normal? 

After the gateway refreshes at 3.30PM this is what I see: 

Alienvolm_2-1624476941945.png

Moreover, I have noticed that the paginated report timestamp in the reports that were not refreshed were at an unusual time: we refresh the reports at 3.30PM every day, but the timestamp shows that the report ran at 4AM in the morning, when there are no scheduled refreshed and no one could have requested a report. 

 

For example, the report that was generated after the refresh today is not the latest version I published 😐 and the timestamp is this: 

Alienvolm_3-1624477224822.png

 

Thanks again for your help! 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors