Forum Discussion
Datasheet view of table - column order question
Hello,
I have two tables: Orders and hist_Orders. When I import the tables into Power Query (import method), the columns of both tables are the same in order (non-alphabetical and matching the way they are in the SQL server Table) and datatype and they match each other. I exit Power Query and go into the Power BI Desktop. When I go into PowerBI desktop and view the tables in the Fields list, the columns are in alphabetical order, and match each other. When I veiw the tables in datasheet view, the column orders do not match, and they are not in alphabetical order, nor are they in the order that Power Query imports. How do I re-arrange the columns, in datasheet view so it matchs the column order that Power Query imports?
Cheers,
Peter
It should be sufficient to order the columns in Power Query, and then UNION the tables in DAX. But if you have already done that column ordering in Power Query you can combine the tables there much faster, using
let Source = Orders & hist_Orders in Source
3 Replies
- lbendlin
Super User
Normally there is no need to do that (unless you compare the tables via DAX). In most cases neither sorting rows nor rearranging column brings you any benefit. If you can, ignore it.
- lbendlin
It should be sufficient to order the columns in Power Query, and then UNION the tables in DAX. But if you have already done that column ordering in Power Query you can combine the tables there much faster, using
let Source = Orders & hist_Orders in Source