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 dimensional tables but no transactional tables.
Really need help please.
1 Reply
AH-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
