Ordenar columnas en modelo de datos

[Anonymous]

Estoy tratando de ordenar las columnas en tablas dentro de un modelo de datos usando POWER QUERY. Pero cuando aplico y cierro para ver los cambios en el modelo de datos de POWER BI las columnas salen en otro orden distinto al que definí en POWER QUERY

[Icey · Accepted solution]

Hi @Anonymous ,

When you meet this issue, go to Power Query Editor, try to uncheck "Enable Load" and then re-order your columns. Then check "Enable Load" again, to reload your data.

Or, uncheck "Enable Load" -> "Close & Apply" -> "Transform data" -> check "Enable Load" ->  "Close & Apply".

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[mahoneypat]

Here's a good power query trick.  Hold Ctrl and click the columns in the order you want and then right click and choose Remove Other Columns (even if you've selected all the columns).  It will put the columns in the order you clicked.  Note: if you've already made DAX calculated columns on that table, those will not alway be at the end.

Regards,

Pat