Power Query would not load more than 100 rows RRS feed

  • Question

  • Hi guys, I have an Excel table with around 1488 rows that I have loaded into Power Query. After shaping up data in the Editor, when I try to load the rows to an Excel sheet, I don't get more than 100 rows. I have tried clearing up cache, set all data sources' privacy levels to none but no luck. Any ideas?

    Excel version: 2010

    Power Query version: Latest

    Computer specs: Windows 7 Pro, 32 GB memory, Intel Xeon processors.



    Friday, September 16, 2016 8:43 AM