Forum Discussion
Problem with incremental refresh on power bi premium
hi SLI
Do you have a specific date column defined as LastUpdated date and specified the incremental policy in a the relevant table? Also make sure you have loaded the hisotrical data and refresh rows in the last ( XX) days. detect data changes also critical to LastUpdatedDate changes.
Hi oscarmqz
yes my problem was resolved by adding a new column (dateLastUpdate) that i used for my RangeStart and RangeEnd filter
this column isn't updated in the source data, it shows only the last date of the update
please refer to this documentation
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#filter-date-column-upd...
regards
hi SLI
How did you generate the "dataLastUpdate" column? I am having issues with duplicated values and my date.time column is comign from source system.
Thanks
Hi Anonymous
Sorry for the delay of my answer i've created a new column named "DateOfUpdate" and update this column with the datetime of the insertion of data
This solved my problem
the column has been added directly on the datawarehouse and data updated by SSIS
best regards