Forum Discussion

A7T57ZZ's avatar
A7T57ZZ
Frequent Visitor
4 years ago

Data not displaying when mixing queries using Model cardinality

I have created a visual that is based off 2 queries but am having trouble getting the data to display how I want it.  If I place the query 1 data columns in the first columns then place query 2 data columns after that I have no issue.  If I mix the order of Query 1 and Query 2 columns, I only see the data that is available before the first placed column of Query 2.  I hope this makes sense!

 

Q1C1 Q1C2 Q1C3 Q2C1 Q2C2 Q2C3 - this works fine

 

Q1C1 Q2C1 Q2C2 Q1C2 Q2C3 - This only displays the data from Q1 that occurs in order before Q2C1

Need Help

1 Reply

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi A7T57ZZ ,

     

    We need more information, could you please share the relationships between tables and some sample data?

     

    And please check if it is because of aggregation, set all fields in the visual to "Don't summarize" and see how the output differs.

     

     

     

    Best Regards,
    Winniz