Power BI incremental refresh in Microst Fabric

[DataAnalyst7]

 

I have implemented Incremental refresh on a Power BI report by using Parameterized Filtering on dates, after publishing the report it get refreshed fine first time but when ever I am trying refresh it again its showing me following duplication error with different tables, even though  there no duplication present in Actual tables. This is the error I get: 

Column '<"Column Name">' in Table '>"Table Name">' contains a duplicate value '<Value>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

can someone help me out.

[AnkitKukreja · Accepted solution]

Hi @DataAnalyst7 

This generally happens due to cardinality issues, try to fix that and see what table or column error refers to? This generally guides you to the right direction.

https://community.fabric.microsoft.com/t5/Desktop/Refresh-error-quot-contains-duplicate-value-and-th...

[lbendlin]

Remember that RangeStart must be inclusive and RangeEnd must be exclusive

RangeStart   <=   <"Column Name">   <   RangeEnd