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,
I have a Power BI query that has worked perfectly for months, but now a query is doing something I have never seen before.
In one step, I have merged two tables.
Note 'statuscode_display' column values.
In the next Applied Step, I have expanded the merged table columns.
Note that the 'statuscode_display' values have been cleared out entirely.
Why am I losing the column data?
Thanks in advance for your help!
Michael
Hi @stmicbarr ,
The reason that casue this issue is that there is no corresponding value in the right table when you are using left outer join to merge two tables in power query.
About merge tables and join kind, you can refer these articles that could help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
The 'statuscode_display' column is not related to the merged query or expanding it to reveal the new columns. This is simply the step in the query where the values in the column disappear.
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.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |