Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

merge query columns coming up as blank



When I merge queries, the columns for the merged queries come up as blank or null. What might be causing this? Thanks. 

Screenshot (13).png

Helper I
Helper I

Thanks Migasuke, figured it out. You are correct: the data types did not match.

Solution Sage
Solution Sage

Hi @kendall ,

If you merge two queries and you receive blank there are usually two reasons:
1. There is no match between tables.
2. Data itself contains blanks.

Best troubleshooting is:

1. Check if you selected proper columns for the merge.
2. Check if the data types are the same in both tables.
3. Check if the values are really matching, for example EUR vs eur. , this will not merge properly.

Let me know if it helps.

If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors