none
Buffering & Referencing Queries RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Understood, thanks Ehren!
    Tuesday, November 15, 2016 10:10 PM