Merge Queries in Power Query bringing blank values

[Anonymous]

Hi 

I have a report I've been running for a couple of months. 

There's a table in the report that's merged with another (left join) using the UserID columns. This has been working fine so far. 

So UserID columns in both tables have blank values. For somereason when I refreshed my data today, the merge has brought back all the blanks from the table on the right. Hasn't happened to date. 

I can not figure out why this is happening. And I've troubleshot this as much as I can. Does anyone have any idea why this is happening now? 

Thanks

[Anonymous · Accepted solution]

Hi  @Anonymous ,

The <blank> appears because there might existing some records in one table didn't find the matched records in the other table.

If you want to replace the blank value, you can replace the value in power query – right-click the column .

This is the related document, you can view this content:

Solved: Merging tables with blank fields - Microsoft Power BI Community

Solved: Combine columns if not null or empty - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

But what if the all entries are there in there other tables but I am still getting nulls on the merged table?

[Anonymous]

What's your 'Join Kind'? 
Left Outer Join works for me once I've replaced all the nulls in the left table with a value. 

[Anonymous]

So.. I've followed the instructions from here, applying a value to the blank fields in left table - 

https://community.powerbi.com/t5/Power-Query/Merging-tables-with-Left-Join-returns-rows-with-no-matc... 

Still unsure how it was running perfectly fine without having to do this before though.