Forum Discussion
Power BI incremental refresh in Microst Fabric
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.
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.
2 Replies
- AnkitKukrejaSuper User
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.
- lbendlinSuper User
Remember that RangeStart must be inclusive and RangeEnd must be exclusive
RangeStart <= <"Column Name"> < RangeEnd