none
Buffering & Referencing Queries

    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?

    Thanks,
    Simon

    Saturday, September 10, 2016 11:47 PM

Answers

  • 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.

    Ehren

    Tuesday, November 15, 2016 9:01 PM
    Owner

All replies