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.
I have load 4 tables from google analytics with idetntial fields.
i need to union this tables and work with union data, but field's sorting in one table is differ from other: http://joxi.ru/vAWDOn6S1kNabr
Why and how fix this trouble?
The sorting of fields is generated from the data source. You may check the Power Query for retrieving data in Advanced Editor. However, you can reorder the columns in Query Editor.
As your 4 datasets have same columns, different column sorting doesn't impact if you UNION those multiple datasets via "Append Query".
Regards,
Simon Hou
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |