Buffering & Referencing Queries RRS feed

  • Question

  • Hi guys

    I have 3 queries in total.  Query 1 decompresses a .ZIP file from a website containing several .CSV files.  Queries (2) and (3) filter Query (1) to isolate the appropriate CSV and then perform some ETL.

    However, it appears that the website is queried more than once upon refresh.  This results in long query time and server load.  Is there a way to cache Query (1) so the following two queries which reference it run against a buffered .ZIP?


    Saturday, September 10, 2016 11:47 PM


  • Hi Simon. This is a known issue we've been hearing about. Currently, each query you refresh in Excel is treated in a standalone fashion, and caching is siloed, rather than being shared cross-query.


    Tuesday, November 15, 2016 9:01 PM

All replies