Excel 2016 query editor load first 50 columns
![excel 2016 query editor load first 50 columns excel 2016 query editor load first 50 columns](https://osiprodwusodcspstoa01.blob.core.windows.net/en-us/media/57df55e1-643c-4fd3-ab33-efb48b7bc715.png)
The reason is the table itself is about 120 columns long, and I only need three columns, and I have about 20 of these similar queries and it's starting to hog memory. This way, it never has to load the entire table into Power Query. What I want to do is define the source table as the "Legend_Data_Merged" table, but choose which columns to pull from that table in the same operation. Now you have two options: Return Data to Microsoft Excel this will return your query results to Excel and complete the Wizard View data or edit query in Microsoft Query this will open the Microsoft Query window and allow you to modify you Microsoft Query Optional: Edit Query.
![excel 2016 query editor load first 50 columns excel 2016 query editor load first 50 columns](https://www.mssqltips.com/tipimages2/7045_what-is-power-query.006.png)
I think this way is first pulling the entire table into Power Query, then stripping down from there. #"Removed Other Columns" = Table.SelectColumns( I know that can be accomplished by loading the table into Power Query and then choosing the columns I want to use.
#Excel 2016 query editor load first 50 columns professional
I want to select specific columns within that table. Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel 2013 Standalone Power Query Public: Available for all other Office 2013 Desktop SKUs. If any of your lines contain extra columns, this approach won’t work I’ve noticed a difference between how the Power BI Desktop and Excel 2016 behave with this code: the current Excel 2016 Query Editor will keep any line breaks after splitting on them, whereas Power BI Desktop does not. I'm using Power Query in Excel to reference a table within the same workbook.