Power Query keeps on calling stored procs even after a query has finished RRS feed

  • Question

  • I have a PQ query, let's say Query1 that calls a PQ function, let's say, fnc_callUSP("usp_One") It is a generic function that can call any stored proc

    When Query1 completes, something inside the workbook/Power Query continues to call(execute) the usp, usp_One

    This is not good. Does anyone have a really good answer or have come across this before and knows what it is or that it is actually an issue or a bug.

    This is hugely worrying in our current PROD environment.

    It goes further in that it somethimes also calls other stored procs.

    It looks like a mess up with cache or something similar

    I'm becoming less and less impressed with PQ

    Sign here

    Monday, September 14, 2015 1:22 PM