How to selectively import columns in Power Query

[cr731]

Whenever I build a query using Power Query using the user interface, it ends up importing the whole table, and then I use Remove Columns to get only the columns I want. Is there a way to combine this into one step so I choose which columns I want as it imports, rather than a two-step process?

Thanks

 

[Matt Allington]

Is it really power query you are using? If so, just select "edit" instead of load, and you can remove them from there. If it is actually power pivot load, you can deselect them by selecting the filter option against the table.