Forum Discussion

elimleung's avatar
elimleung
Frequent Visitor
1 year ago
Solved

How to do incremental refresh in power BI without duplication?

I have a table like following in my SQL Database and is loaded into Power BI where the Last Update Date have been setup for Incremental Refresh with 2 days windows using the rangestart and rangeend. ...
Need Help
Deku's avatar
Deku
Icon for Super User rankSuper User
1 year ago

You can set a longer active window and use polling expressions. The polling expression would only allow a partition if refresh if the max updated date for that partition is greater then the bookmark from the last refresh of that partition. 

 

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#custom-queries-for-detect-data-changes

 

https://www.google.com/amp/s/blog.crossjoin.co.uk/2022/07/31/custom-queries-for-detect-data-changes-in-power-bi-incremental-refresh/amp/

elimleung's avatar
elimleung
Frequent Visitor
1 year ago

Thanks Deku. I will try.