Refresh doubts for the load disabled scenario RRS feed

  • Question

  • Hi, 

    I build 3 queries in PQ and all 3 queries are connected to a same DB. The second query is based on the first query's result and the third query is based on the second query's result. However, what I want is the last query's result. To shorten the loading time, I disabled the loading for query1 and query2. Only load the last query's result to the worksheet. My question is, for such a scenario, when I refresh the query will I get the correct result? Will the query1 and query2 be refreshed at the same time even the load is disable for them?



    Wednesday, January 21, 2015 1:38 AM


  • Hi Qilong,

    Yes, you will get the correct result. The 2 disabled queries will be evaluated and their outputs will affect what is evaluated and returned by the final query.


    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website:, Twitter: @nimblelearn

    • Proposed as answer by Gil RavivMVP Thursday, January 22, 2015 9:21 AM
    • Marked as answer by Qilong L Friday, January 23, 2015 12:13 AM
    Wednesday, January 21, 2015 9:17 AM