Forum Discussion
Direct query relation ship error unable to get column from more than two tables in a matrix in PBI
We are using Direct query option to get connected with datasource. We have also pulled 33 tables and created relation ship between all the tables .
In the report view i am trying to build a matrix by pulling atleast one columns from each table. the Matrix is working fine till two tables and when i try to pull a column from third table it's throwing relationship error . All the fields available in my datamodel are of text no measures involved. We tried creating bridge table and applied cross filter direction too, in that case we are getting cartesian product in the matrix . Is there any other approach avilable in PBI to build a matrix by pulling columns from all the 33 tables.
2 Replies
- edhans
Community Champion
You need to model your data for a Star Schema. Power BI isn't SQL Server where you just pull in tables and create joins. It is build on the Query Model, or Dimensional Modeling, and works best - far better - when in Import mode with a Star Schema.
If you must use direct query, you still need to model those tables either in Power Query or better yet by creating acceptable Views base on a dimensional model in the data source, then import the correct FACT and DIM tables. 
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
Could you please consdier sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here.
It makes it easier to give you a solution.Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
