Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I merge queries, the columns for the merged queries come up as blank or null. What might be causing this? Thanks.
Thanks Migasuke, figured it out. You are correct: the data types did not match.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.