Query Dependencies - Execute Queries In Custom Order

[captainlaw]

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!

[EarlyLearner]

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

[Eric_Zhang]

---

@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]

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]

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?