Forum Discussion

JoeBrown7's avatar
JoeBrown7
Frequent Visitor
3 years ago

Relationship between queries imports from other datasets - data missing in table

Hi, I have 2 queries in my report. 1 is a query imported from a local source (Query 1). The other query is imported from another dataset (Query 2).  I've created a many to one relationship betw...
Need Help
PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
3 years ago

Hi JoeBrown7!
You can go to the field on your visual, right click on it and select "Show items with no data", that should do it.

 

Let me know if that helps!

JoeBrown7's avatar
JoeBrown7
Frequent Visitor
3 years ago

Thanks for the reply Pablo. When I select this option, it then takes forever to load, and then when it does it says data is too large. The actual table in 'Query 2' is only maximum 10,000 lines. So, I wasn't sure if I was doing it right, or selecting the correct thing. Any thoughts on what could be causing this please ?