![excel 2016 query editor load first 50 columns excel 2016 query editor load first 50 columns](https://www.excelcampus.com/wp-content/uploads/2015/03/Power-Query-in-Excel-2016-for-Windows-Data-Tab-of-Ribbon-Get-and-Transform.png)
The query shows 'Retrieving Data.' but the row-count never updates nor does it show any source files being loaded.
![excel 2016 query editor load first 50 columns excel 2016 query editor load first 50 columns](https://datachant.com/wp-content/uploads/2016/12/Screenshot_7-1400x747.png)
Result : if the Query settings are changed to 'Load to Data Model' (irrespective of load to Table, or Connection-only) then the query goes into a spinning-wheel-of-doom.
![excel 2016 query editor load first 50 columns excel 2016 query editor load first 50 columns](https://www.biinsight.com/wp-content/uploads/2019/03/Filter-a-Column-by-a-Column-from-a-Different-Query-in-Power-Query.jpg)
show variationof latest week against average of preceding weeks).
EXCEL 2016 QUERY EDITOR LOAD FIRST 50 COLUMNS ISO
Problem : on trying to develop this, I wished to be able to load the table to the Workbook Data Model, in order to add some measures, based on ISO Week calendar (e.g. The PQ got somewhat slower, as the data got more extensive, but still ran fine. This ran successfully over several months with a new CSV data file being added to the list every week. Output was a table loaded to workbook only. The table was extensively cut with ~80% rows filtered out, unwanted cvolumns removed, and some new data columns added. Background: A PowerQuery had been successfully combining data from a dozen large (101 cols x 100,000 row csv files.