Forum Discussion
Multiple tables: relationships
I have multiple tables and cannot build relationships accurately since I am now using Direct Query. It worked fine with import. I cannot build the typical star schema. I have multiple dimensi...
RayWu
Memorable Member
Memorable MemberAH-Ohio
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-troubleshoot
Hope this help.
Might also be a limitation for direct query mode - https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-directquery