Forum Discussion

James-BQT's avatar
James-BQT
New Member
5 years ago
Solved

Relationship. Dim table column can't create a relationship with the Fact table. Zero Duplicates.

I am new to this group and Power BI.  I have been working with it for several months and now getting more serious.   The fact table, I made query of one column, remove duplicates, sorted, and added...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi James-BQT,

    I think you need to manually rebuild the relationship mapping between these tables because you remove the raw key field.
    If you turn on the 'auto-detect the relationship', power bi will detect data model table fields and try to map them with similar name and type fields. (It does not mean they will auto use the new field to keeping original relationships)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi James-BQT,

I think you need to manually rebuild the relationship mapping between these tables because you remove the raw key field.
If you turn on the 'auto-detect the relationship', power bi will detect data model table fields and try to map them with similar name and type fields. (It does not mean they will auto use the new field to keeping original relationships)

Regards,

Xiaoxin Sheng