Return step of a referenced query.

[PietroFarias]

One doubt I had a while ago and wanted to confirm now.If I refer to a query, I just type '= NameQuery'.

Now, is it possible to refer to a step of the query, not the result of the query, as I exemplified?

[v-piga-msft · Accepted solution]

Hi @PietroFarias ,

I still have a little confused about your question.

It seems that you want to refer to the steps in another query.

If so, I'm afraid that we cannot achieve that directly with typing '= NameQuery'.

By my research, there is no good solution for your requirement in power query.

As a workaround, you could delete the steps you don't need for reference in query 2 and then you could refer to the query 2 in query 1.

Maybe @ImkeF  will have other ideas.

Best  Regards,

Cherry

[PietroFarias]

hi @v-piga-msft 

Exactly. I want to refer to the steps in another query. I still am learning about the possibilities of M. And I thought there was something similar to this.
About your suggestion, I do it sometimes.

Thanks.

[v-piga-msft]

Hi @PietroFarias ,

Does my reply make sense?

If it is helpful, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry