duplicates issue

Thanks for the reply from aj1973 , please allow me to provide another insight:

Hi, Ranjith_96 

Regarding the issue you raised, my solution is as follows:
1.First of all, based on the error, we think we still need to check for hidden duplicates to make sure that there are no hidden duplicates in the "fact_subscribers" table. You can try using deduplication in PowerQuery.

Of course, you can also turn on the following settings in PowerQuery to see if there are invalid values in the data.

2.Second, check if the data types are consistent:

Double-check that the data type for sub_id matches in the fact_subscribers and fact_billings tables. Sometimes, mismatches in data types can lead to unexpected behavior.
 

Here is a screenshot of the official documentation:

Here's how to change the data type in PowerQuery:

3.Then verify the relationship to make sure that the relationship you established between the "fact_billings" and "fact_subscribers" is correctly defined as many-to-one, with the "fact_subscribers" on the "one" side.

4.Finally, check the incremental refresh policy: make sure that the incremental refresh policy is configured correctly and that the partitions generated by the policy are not introducing duplicates.

Of course, you can also try to temporarily disable incremental refresh and try a full refresh to isolate if the issue is related to the incremental refresh configuration.
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.