Forum Discussion
Duplicate Value
Evething is okay until yesterday but I got an refresher error this morning. It said that FACT_ORDERS table contains a duplicate value, so I go to the database and write a simple query to check: there...
Are you using incremental refresh on this table?
Yes, I am. Does it make this error? Could you explain for me? Thank you
Check that you're using < RangeEnd, not <= in your filter.
I'm using < RangeEnd 😠I still don't know why this happened. Why is it related to RangEnd and incremental refresh?
Why improperly setting RangeStart/RangeEnd filters can lead to duplicates is documented here:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#filter-data
In your case it doesn't seem to be the root cause for your duplicates. If there are no duplicates in your source data then I'd doublecheck that I have nothing in my ETL (e.g. appending tables) that may cause these duplicates.