Incremental dataset refresh

Hi PBILover,

Looks like some conditions did not fully met, while power bi supports selective partition refresh using detect data changes, but it only works when a few key conditions are met:

• The query must fully support query folding all the way to the data source (in your case, Synapse).
• ModifiedDate must be a datetime column and used as both the range and change detection column.
• Partition specific refresh takes effect only after the first full refresh.
• This feature is supported only in Premium, PPU, or Fabric capacities but not in Pro.

If any of these are not met, power bi will default to refreshing all partitions in the incremental range.

To confirm I recommend checking query folding, you can use the refresh history and verify which partitions were actually refreshed.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa