Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 no duplicate values showing.
I found the solution in PBI Community (use Remove Duplicates in Power Query) but I really want to know what caused this issue. Does anyone know?
Thanks!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.