Forum Discussion
Relationship issue with composite data model in Power BI
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.
Hello Martin_D
Also can you brief why it is throwing issue while using import and direct query mode both together, cz when I've tried both table in import mode, it is working fine with relationship as well as related function.
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.