Forum Discussion
The column order in Data table isn't the same as in Power Query!
Hello friends, I've been googling for a solution to no avail. I want the order of columns in data table view to be the same as it is in Power Query Editor. How can I force Data Table to display c...
I found really disappointing being able to move columns in Power Query to the left or right... and then having no effect in Power BI... not allowing something as simple as UNION of 2 tables because the columns are not in the same order...
Since this is absolutely insane, I assume the problem should be mine... any ideas?
- ToddChitt
Super User
What problem are you trying to solve with the specific ordering of columns in Power BI?
I was triying to add one table to another... finally as suggested above I used APPEND in query instead of UNION.
(this brings to me into a nice problem with incremental refresh, but it is another hiostory, solved already)
Thanks
See my post to the original message with the solution
