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.
Hi All,
So I came accross this strange behaviour when trying to append a table and then merging this table with another query.
Table 1
Column 1 Type Text
Column 2 Type Any
Column 3 Type Whole Number
Table 2
Column 1 Type Integer
Column 2 Type Any
Column 3 Type Whole Number
Rsults in following Append:
Column 1 Type Any - which makes sense because I append two different column Types
Column 2 Type Any
Column 3 Type Whole Number
Then I merge with an left outer join with a table that also has column 1 but Type Text.
When I then look at the result of the merge - the values from Table 1 that have column 1 Type Text populate properly while all of the other values in the append table column 1 coming from table 2 with type integer are omitted from the merge.
Is this intended behaviour?
M
Solved! Go to Solution.
Seems odd. Can you post sample data to experiment with?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
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.