When Adding column from other table, it filters my rows

Hi,

I'm having trouble with building my report which is based on a table visual.

I'm connecting columns from multiple tables into 1 visual so that all the information is in 1 overview.

All the tables have a relationship which works.

For example:

Table 1 has 1 column server name that I got from Active Directory (500 servers)

Table 2 has 2 columns that I got from WSUS (Server names & Updates needed)

Both server name columns have a relationship

Now when I make the overview in the visual, and put in the server name column from AD and Updates needed column from WSUS I only have about 300 servers in the overview. The other 200 servers are not in WSUS (apparently), and those rows are filtered of the visual. I need that specific value to stay empty. so that I get an overview of the 500 servers from AD with some servers needing updates, and those where updates needed is empty, mean I need to get them in WSUS.

Bu I can't seem to get this done?