Forum Discussion
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.
| Primary Key | Col B | Last Update Date |
| 1 | Value B1 | 01/01/2025 |
| 2 | Value B2 | 01/04/2025 |
Today is 16 MAY 2025 and I have made a change on the first record
| Primary Key | Col B | Last Update Date |
| 1 | Value B1 New | 16/05/2025 |
| 2 | Value B2 | 01/04/2025 |
Without refreshing the whole semantic model how to avoid the first record being duplication in the semantic model?
Required result
| Primary Key | Col B | Last Update Date |
| 1 | Value B1 New | 16/05/2025 |
| 2 | Value B2 | 01/04/2025 |
Potential Result
(Record 1 is duplicated)
| Primary Key | Col B | Last Update Date |
| 1 | Value B1 | 01/01/2025 |
| 2 | Value B2 | 01/04/2025 |
| 1 | Value B1 New | 16/05/2025 |
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.
5 Replies
- Deku
Super User
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.
Thanks Deku. I will try.
Hi elimleung
Thank you Deku for the helpful response!
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question
Thank you.Hi elimleung
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If our response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you.Hi elimleung
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.Thank you.
