Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
JoeBrown7
New Member

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 between the unique ID numbers, which are common in both queries. The Unique ID may not necessarily be in 'Query 2'. 

I have created a table in a report to show every line in 'Query 1', however, I want to add a column from 'Query 2' to this table. When I add this column, it removes the lines where those Unique IDs are not in Query 2.

How do I still keep those lines in Query 1 which do not have a link to Query 2, in the table visual, please? Just to show that particular cell as 'blank' in the table for the column I am adding from 'Query 2'

FYI - I have tried clicking the 'show items with no data' on the new column, but it 'errors' with too many lines being imported

 

2 REPLIES 2
PabloDeheza
Solution Sage
Solution Sage

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.

PabloDeheza_0-1670333739215.png

 

Let me know if that helps!

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 ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors