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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JimJim
Helper V
Helper V

Scheduled Refresh not refreshing one table

So I have a report with several fact tables, the biggest one which I will call Sales has about 15 million rows. Scheduled refresh runs daily (import) and isn't updating this one table. I will try my best to explain what has happened.

 

On my report I have a measure that returns the monthly sales value, the value for August 2023 is about 2.6 million. Yesterday I got complaints from the business as it was only showing as 1.8 million. The scheduled refresh had completed successfully. I hit the refresh button on the report to refresh the visuals, nothing changed. I refreshed the dataset, nothing changed. I then refreshed the visuals again and this time the value updated to 2.6 million. 

 

The next day after the refresh completes the number drops back to 1.8 million. I hit the refresh button on the report to refresh the visuals, nothing changed. I refreshed the dataset, nothing changed. I then refreshed the visuals again and this time the value updated to 2.6 million. 

 

2 days in a row the same thing has happened. I can't keep manually refreshing the datset and refreshing the visuals. Does anyone have an idea what the issue could be?

1 ACCEPTED SOLUTION
yuerdingdang
Regular Visitor

4 REPLIES 4
yuerdingdang
Regular Visitor

Thank you, incremental refresh resolved my issue

yuerdingdang
Regular Visitor

Seems like a refresh time-out issue. If you have multiple tables in your report, try to set up the refresh to run in a sequential manner, instead of simultanously.

Just so I'm clear, you mean disabling parallel loading of tables?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors