Forum Discussion

crazycrocodile's avatar
crazycrocodile
Frequent Visitor
3 years ago
Solved

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 PB...
Need Help
  • crazycrocodile's avatar
    crazycrocodile
    3 years ago

    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. 

crazycrocodile's avatar
crazycrocodile
Frequent Visitor
3 years ago

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.