Solved: Re: Power BI incremental refresh in Microst Fabric

DataAnalyst7 · ‎03-04-2024

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 · ‎03-04-2024

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...

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

View solution in original post

AnkitKukreja · ‎03-04-2024

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...

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904