Forum Discussion

Krupa_Parmar's avatar
Krupa_Parmar
Regular Visitor
3 years ago
Solved

Relationship issue with composite data model in Power BI

I've prepared on composite model with one DQ table and one import mode table and connected both the tables as one to many from import to DQ mode table. here, as shown in image, order table is in DQ m...
  • Martin_D's avatar
    Martin_D
    3 years ago

    Relationship between import mode tables from any source = strong relationship = RELATED() is supported

    Relationship between Direct Query tables from same SQL database = strong relationship = RELATED() is supported

    Relationship between any import mode table and any Direct Query table = limited relationship = RELATED() is not sopported

    Relationship between two Direct Query tables from different sources/databases = limited relationship= RELATED() is not supported

     

    Your situation that is throwing the issue is the 3rd case.

    Your situation that works is the first case.

     

    Reason: Functionality as provided by Microsoft.