Forum Discussion
Incremental refresh doesn't load data for the current month
Hi,
I am running into an issue regarding incremental refresh.
I have implemented incremental refresh using Tabular Editor due to large size of the file (couldn't do the first full refresh on PBI Service due to a timeout). Then I have processed the partitions in SSMS.
For one of my tables, only partitions up to 2023Q205 (May) are filled with data. All partitions created for June (one per day) are empty, even though there definitely is data for these dates. I have confirmed that by doing a refresh of the table in PBI Desktop - and data up to 12th June (yesterday) was loaded successfully. However, even after multiple refreshes via PBI Service and SSMS, the partitions for June remain empty.
Other tables managed to load June data without any issues.
My rules for incremental refresh for each table are refresh data from the past 5 days, hold data from the past 10 years.
Am I missing something?
In case anyone runs into a similar problem in the future:
The only way I managed to fix this was by deleting the entire table from the data model, refreshing data (PBI Service), then add the table again. I guess the problem was in the hidden calculated tables for date columns. Only re-doing the incremental refresh rules is not enough, you need to get rid of the entire table and re-add it.
1 Reply
In case anyone runs into a similar problem in the future:
The only way I managed to fix this was by deleting the entire table from the data model, refreshing data (PBI Service), then add the table again. I guess the problem was in the hidden calculated tables for date columns. Only re-doing the incremental refresh rules is not enough, you need to get rid of the entire table and re-add it.