Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

The report is showing old value even after incremental refresh

Submitted by Anonymous on ‎02-23-2023 01:52 AM

Hi Team,

 

We have a dataset with import mode tables, we have added incremental refresh on the fact tables. when we execute the report one of the measure is still showing old values, whereas the local copy on power bi desktop is showing correct value with respect to the database.

 

Please support on this ticket.

 

Thanks,

Karunakar 

Status: Investigating

Hi @Anonymous ,

 

The filter on the date column is used to dynamically partition the data into ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update. If the deletion occurs in the historical range and not the incremental range, it won't get picked up. This can cause data refresh failures due to partition-key conflicts. Please check if you have met this limitation.

 

Also,you may refer to Solved: Incremental Refresh - Report not updating in servi... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn

 

 

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎02-23-2023 06:52 PM
Status changed to: Investigating

Hi @Anonymous ,

 

The filter on the date column is used to dynamically partition the data into ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update. If the deletion occurs in the historical range and not the incremental range, it won't get picked up. This can cause data refresh failures due to partition-key conflicts. Please check if you have met this limitation.

 

Also,you may refer to Solved: Incremental Refresh - Report not updating in servi... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn

 

 

Idea Statuses