Reordering columns in Power Query editor
I have been extensively using Power Query at work to automate pulling data from 20 different excel files, access data base and other sources. What I really like about Power Query is I can reorder the columns in each of my data pulls in power query editor and then append more than 20 data tables i...
Ability to insert a new column at specific location, before or after column #10 or column name, would be very helpful in power query
I usually add about 10 new columns in power query after I have pulled and shaped the data from different sources. After adding these columns I move them to a different location in power query editor. It is currently very painful to move columns in power query editor (since there is no way to reor...
Debugg in power query
It would be helpful to get an option to debug the steps in power query. When I am working with large datasets power query is processing data smoothly until I apply a step inadvertently resulting in it slowing down, extremely slow like it would take 15-20 mins to refresh the query which was taking...
data type
Suggestion: Automatically assign same datatype to a new column which in generated by performing a mathematical operation on 2 or more columns in Power Query. Currently, I add a step to change data type for a new column that I am generating after performing mathematical operation on 2 or more co...