cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kavs30
Helper I
Helper I

Facing issues with incremental refresh unable to fetch the update record

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

 

Kavs30_2-1622978202436.png

Now my data has changed to 

 

Kavs30_3-1622978611218.png

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

 

Kavs30_4-1622978705431.png

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?

 

 

 

 

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Kavs30 

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.

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

v-xiaotang
Community Support
Community Support

Hi @Kavs30 

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

vxiaotang_0-1624344145055.png

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

 

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.

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors