Incremental Refresh Error

[Anonymous]

Hello,

I have set up an incremental refresh on my Power BI report and keep getting duplicate value error. I do not have any additional relationship setup. The relationships are the only ones that I need. See the error below - 

Yes, there is a many-to-one relationship but there is no duplicate value in the view/table that I am using.

Following is incremental refresh setting -

I am refreshing the report every 2 hours

[mwegener]

Hi @Anonymous ,

with the incremental refresh, you already have a version of the ID stored in the Power BI Service.

[Anonymous]

@mwegener 
So how should I deal with this error? It has the latest Modified date so it should typically refresh the data.

[mwegener]

Hi @Anonymous ,

Incremental loading in Power BI is intended for fact data, not for master data.

Power BI only updates the refresh range (partition), not any modification.

The data outside the refresh rage must be stable (unchanged).

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

[Anonymous]

@mwegener 

Thanks a lot.

So how should I be dealing with the issue here? What I have is a ticket data which can be updated. 

I would appreciate it if you can provide me some solution or ideas to handle this. 

[mwegener]

Hi @Anonymous,

I don't know the whole model, but I see two options.

1. Do without the incremental refresh.
2. Increase the refresh rage.

How long is the refresh time for two years?

How long does the ticket information change?

[Anonymous]

@mwegener 

Thanks for the help.

I think I figured out. This is what I did, I set up an Incremental Refresh based on Submit Date.

And selected Detect Changes on Last Modified Date.

[v-deddai1-msft]

Hi @Anonymous ,

Thank you for sharing the solution. Would you please accpet your reply as answer so that people with the same issue will find the solution fast.

Thank you for your support and understanding.

Best Regards,

Dedmon Dai