Forum Discussion
Union Table get error, two column not match.
I have two same table, they from same data source, one is history data, don't need refresh , second one is current data, when we click refresh, Power BI will just refresh second one, this will help the performance, for user easy understand, I will union them together, to show all the data to user, but after I union this two table, get error for the column not match, here is the error, last two picture show why I need union, and show my data source, I didn't make any change for data source, just filter the data, why when they union get wrong result? how to fix this, thank you
Anonymous,
Based on the first screenshot, I note that you mix data which have different data types in the columns of Union table. I suspect that you have different orders of columns in Detailed Vendor ledg_Entry_History and Detailed Vendor ledg_Entry_Current, if so, please create the Union table by combining UNION() function and SELECTCOLUMNS() function, there is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/External-Mapping-for-data-mashup/td-p/268193
Regards,
Lydia
1 Reply
Anonymous,
Based on the first screenshot, I note that you mix data which have different data types in the columns of Union table. I suspect that you have different orders of columns in Detailed Vendor ledg_Entry_History and Detailed Vendor ledg_Entry_Current, if so, please create the Union table by combining UNION() function and SELECTCOLUMNS() function, there is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/External-Mapping-for-data-mashup/td-p/268193
Regards,
Lydia