Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    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's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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