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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JimJim
Responsive Resident
Responsive Resident

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors