Forum Discussion
How to change column order
Microsoft EmployeeHi tonioknuth,
I have tested it on my local environment, when appending query, Power BI will ignoce the oclumn order and append the same column name in a column if you have the same name in two tables.
Regards,
Charlie Liao
Hi v-caliao-msft,
thank you for your quick reply, and your tests!
From what I can see, you are combining the tables on the query level, right ?
In my case, I am combining the tables later in the model, as before uniting them, I have to add columns with table specific values
(e.g. document types: SalesInvoice / SalesCreditMemo)) to be able to calculate correctly in the UNION table.
The column order as specified in the query somehow does not reflect the column order of the tables in the model later.
Do I have the option to take the queries column order over to the model, or should I try to add the needed columns on the query level somehow ?
Best,
Tonio
- v-caliao-msft
Hi tonioknuth,
I combine the tables using append querys in the model. When you have additional rows of data that you’d like to add to an existing query, you append the query. Please refer to the link below.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/Regards,
Charlie Liao