Forum Discussion
Data Duplication Issue in Daily Power BI Desktop Refresh
Good morning, everyone! I'm experiencing a problem with my Power BI Desktop file when it performs its daily refresh after being published to the workspace. My data source is an incremental dataflow...
Show the entire power query code. Which field is the basis for the range filters?
Here is the complete Power Query code. The base field for the filter is updatedat.
Updatedat is not a suitable field. Incremental Refresh needs something immutable like Created Date. Even then you have to refresh historical partitions if the row contents changes.