Forum Discussion
Merge Queries in Power Query bringing blank values
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
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
4 Replies
So.. I've followed the instructions from here, applying a value to the blank fields in left table -
Still unsure how it was running perfectly fine without having to do this before though.
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