Scheduled Refresh not refreshing one table

[JimJim]

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?

[yuerdingdang · Accepted solution]

This article may be helpful: Solved: Customized table refresh sequence - Microsoft Fabric Community

There is a more advanced way to save compute power by incremental refresh Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

[JimJim]

Thank you, incremental refresh resolved my issue

[yuerdingdang]

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.

[JimJim]

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