Forum Discussion

TM_Evan's avatar
TM_Evan
Icon for Helper I rankHelper I
9 years ago
Solved

Unable to do table with 3 or more sources

I am attempting to create a table joining data from more than 3 tables in a single database.   In my example I am able to insert an Order Number (Order), Settlement Data (Order), and Full Name (Per...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    What relationships, exactly, are established? Between which columns in which tables? What are their crossfiltering directions? Cardinality? How are you trying to display these? A matrix? If so have you put anything in the Values box?

TM_Evan's avatar
TM_Evan
Icon for Helper I rankHelper I
9 years ago

I noticed that Power BI (so far) does a good job in selecting the cardinality correctly then. 

As for Matrix vs Table, I totally see that now.  I really appreciate your help as well as others in the community. 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Yeah unless you're deliberately doing something weird it's pretty good at auto-selecting the right cardinality. But I never know if the person asking the question has done something weird. :smileywink: