Query Dependencies - Execute Queries In Custom Ord...

captainlaw · ‎07-27-2017

Hello PBI Experts, I'm trying to figure out if it's possible to change Query Dependencies in Desktop? I opened Query Dependencies, but I cannot change it. I would like to execute queries sequentially but cannot do so at the moment.

Thanks!

Anonymous · ‎08-23-2018

I have the same issue - I need to run queries in a particular order. Is there a way to do it?

Eric_Zhang · ‎07-29-2017

@captainlaw wrote:

Hello PBI Experts, I'm trying to figure out if it's possible to change Query Dependencies in Desktop? I opened Query Dependencies, but I cannot change it. I would like to execute queries sequentially but cannot do so at the moment.

Thanks!

@captainlaw

You could reference this thread Query Dependencies.

By the way, may I know why the execution order matters in your case?

captainlaw · ‎07-30-2017

The order matters because my first query is a sproc and my second query is a view that points to the result of the sproc.

I'll look into your other reference forum.

captainlaw · ‎08-02-2017

The other link you referenced is using json document, which I'm not sure what M function I should use to ensure first query occurs before the second. Can you clarify a bit with one sentance on how to go about?