Power Query Automation

[Fcoatis]

Hello all,

I´m looking for some help in this automation.

I have 3 queries that i need to repeat several times (16 times precisely) passing parameters .

Query 1 would be:

let
Source = Web.Page(Web.Contents(<url> & Param1)),

.

.

.

In

"#Final Result"

Query2:

let
Source = Web.Page(Web.Contents(<url> & Param1)),

.

.

.

In

"#Final Result"

Query 3:

let
Source = Table.NestedJoin(Query1,{"Index"},Query2,{"Index"},"Cod",JoinKind.LeftOuter),

.

.

.

In

"Joined Result"

I wish I could create a list with 16 Parameters and append the 16 Queries 3 results in a consolidated Table. Can you PQ gurus help?

Thanks in advance

Fabio Coatis

[v-danhe-msft · Accepted solution]

Hi @Fcoatis ,

Based on my research, I am afraid you could not make the query for your parameters automatically.

Regards,

Daniel He