Forum Discussion
Ordenar columnas en modelo de datos
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
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.
2 Replies
- mahoneypat
Microsoft Employee
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
- Icey
Community Support
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.
