CODEWITHSUNDEEP
powerbipowerbi-desktoppowerbi-custom-visuals
Iftekhar
Iftekhar

Reputation: 365

Showing null values for some of the Power BI rows

I have joined an excel sheet with the world population web link from Wikipedia in my Power BI tool. When I merge these two tables, it shows me the population only from the United States, other countries have null values.

Would really appreciate the help. Screenshots provided below

Error

while merging

Upvotes: 0

Views: 2231

Answers (2)

Marcus
Marcus

Reputation: 4005

It looks like your merge isn't matching the rows as you expect.

I would try to investigate if there are "invisible" differences in the columnar values:

Canada (with an appended space) will not match to Canada for example. To check for this, go into the table you are merging and select to Trim the key column.

In the table you are merging into, do the same Trim operation for the key column.

Edit: Another option is to apply fuzzy matching to the merging process and to limit the amount of fuzzyness by setting maximum number of matches per row and adjusting the similarity threshold up from 0.80 to something closer to the maximum 1.00 (= exact matching).

Upvotes: 1

Mr Robot
Mr Robot

Reputation: 322

I think issue is left join. Try with join tables with country column to present all columns.

Click dropdown and select full outer feature and expand.

Upvotes: 0

Related Questions