Incremental Refresh Issue with UPDATE_DATE_TIME Field — Data Mismatch in Power BI

Hi manoj_0911 ,

Thanks for reaching out to the Microsoft fabric community forum

rajendraongole1 ,

Thanks for your prompt response

In addition to rajendraongole1 , below are a few workarounds

Enable Detect Data Changes Option

 You’ve already done this good move.

This ensures Power BI checks for changes in the UPDATE_DATE_TIME column even within existing partitions.

 Add a Buffer to the Refresh Window

In your image, you’ve set the incremental refresh to start 2 days before the current date. That’s smart but consider extending it to 3–5 days if updates are delayed longer.

This helps catch updates that arrive slightly late but still within the buffer.

Enhancements

Create a Composite Key for Change Detection

If your table has a unique ID (TXN_ID), consider creating a hash or composite key

Text.Combine({Text.From([TXN_ID]), Text.From([UPDATE_DATE_TIME])}, "|")

Use this for change detection to ensure Power BI identifies updated rows.

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi