Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental Refresh Issue- Data row count getting decreased after publishing and first refresh

Hello Everyone,

 

I  am implementing Incremental Refresh on my Dashboards where I have archived the Data from last 3 years  i.e. from 1/1/2020 to 2/3/2023   and Incrementally refresh data starting for 5 days i.e. 2/4/2023 to 2/8/2023 .

 

When I published this file  and kicked off the first refresh it reduced the  row count from 268M to 265M (Screenshot below) after its first refresh.I see for other tables the  row count increased after the first refresh in power bi service but for some it decreased similar to the one I shared above .

Parameters: 

RangeStart = 1/1/2020 ,RangeEnd = 2/5/2023  IR_Interval = -2 

 

can anyone help me understand what can be the possible reason for this?

 

Per my understanding,If I have archived historical data in my PBI file that data should remain same even after publishing it in the service and it should only bring in the new data after its refresh.

 

Thanks much in Advance

 

 

 

No Replies