Facing issues with incremental refresh unable to fetch the update record

[Anonymous]

Hi All,

I have set up incremental refresh for my fact table as below:

Store rows where column created is in last 5 months. (Created_Date)

Refresh rows where column created is in last 4 months.(Created_date)

Only refresh data in last 4months if max value in Update_Date changes

Now my data has changed to 

But after refreshing the dataset in Service, i only get 2 record instead of 3 updated record. The highlighted record still has old value

I am reading out Microsoft article but not able to understand why this might be happening. I assume this could be related to the partition but i am not able to understand how partition are handled internally and how can i get this record updated too.

Can someone help me with the error, do i need to change something?

[v-xiaotang]

Hi @Anonymous 

Did you refresh the report after dataset finished refreshing? If the dataset refresh completed when the report is open, and you didn't refresh the report manually, then problem would happen.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.

[Anonymous]

@v-xiaotang I did refresh it after the load but same results.

[v-xiaotang]

Hi @Anonymous 

One possible reason crossed my mind. please check whether it is because of time zone.

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#current-date-and-time

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.