PBI Desktop Query Editor - can't drag to reorder steps

[mikegunns]

You can still drag to reorder steps in Excel Get Data (Power Query), but no longer in PBI Desktop. Why?

[MarkLaf]

I can still reorder (Version: 2.54.4970.961 64-bit (January 2018)) in the query editor in PBI desktop.

Maybe try reordering with M and see if that gives you an error?

In case you aren't familiar with writing M, right-click last step, select "Insert Step After" and type:

=Table.ReorderColumns( #"Previous Step", {"Col1 Name", "Col3 Name", "Col2 Name"})

Note that #"Previous Step" should match the name of the last step and the Col# Names should match the columns you are reordering.

[mikegunns]

Hi @MarkLaf, thanks for your response. You're right, no functionality has changed if I'm in the advanced editor writing my own M, but that is far less efficient when you want to quickly reorder a few steps. I'm specifically wondering about the drag-and-drop we used to be able to do.

[MarkLaf]

I can still drag and drop, too, though. That's weird that it works for you when writing out the M but not drag and drop. Maybe try restarting PBI? Not much else I can suggest unfortunately.

[mikegunns]

Out of curiosity, are you using the Microsoft Store version of PBI Desktop or the download installer version?

[MarkLaf]

Download installer (https://www.microsoft.com/en-us/download/details.aspx?id=45331)

[mikegunns]

Perhaps that might be the difference. Hopefully the next update brings it back on the Microsoft Store version!

[vagabond]

To clarify the workaround for anyone wandering by this thread from your favorite search engine: use the MSI-based installer from the PBI Desktop download page, rather than the Microsoft Store app.