Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Fcoatis ,
Based on my research, I am afraid you could not make the query for your parameters automatically.
Regards,
Daniel He
Hi @Fcoatis ,
Based on my research, I am afraid you could not make the query for your parameters automatically.
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |