Forum Discussion
Setup Incremental refresh on Many to Many relationship table
Hi All, I have model where relationship between DIM & FACT is Many to Many , I have used bridge table to reslove m:m issue converting it to M:1:M , but i had to bring all the columns from FACT to...
amitchandak But the below statement from Microsoft docs contradicts with incremental refresh works for many to many , because it expects to have unique values in 1 side of the table , which mean many to many will always fails the above condition.
Anonymous , what issue are you getting for the relation M-M when refreshing data?
Ideally, we do not want many to many, but it should work.
Below is the error i am getting and basically it has SCD type 2 fact table in db, but to resolve m:m in power bi , i am bringing only active recrods ans converting as 1: M and setting up incremental refresh on this fact table.