Forum Discussion
Solved
Append table lost rows
Hi, I'm having a problem loading two queries from different bases and merging them using the "Append as new" option. The resulting table is joining records incorrectly, following examples: Base 1...
dgbraqe, This issue should be now be fixed. Please download the Power BI Desktop July release and let us know if things are now working as expected.
Ehren
dgbraqe,
Create a new append table using DAX below and you should get correct distinct values.
Table = UNION('BASE 1','BASE 2')
Regards,
Lydia
edhans
Community Champion
Community Champion
Anonymous wrote:dgbraqe,
Create a new append table using DAX below and you should get correct distinct values.
Table = UNION('BASE 1','BASE 2')
Regards,
Lydia
Isn't that a workaround? Why isn't it working correctly, or at least, why aren't we understanding it correctly, in the M code?