Forum Discussion
repeat consult
See it all at work in the attached file.
Note I have changed the code for your base query a bit for the example
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
1. Create a function with the code for the query you want to repeat; name it function_ for instance
2. Create another query that calls ont he previous one N times:
let
N_ = 10, //update as needed
list_ = List.Numbers(1,N_),
res_ = List.Transform(list_, function_),
final_ = Table.Combine(res_)
in
final_
This does a union of all the N tables. You can change how you combine them as needed
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Thanks
It works, now I just need to circumvent the cache, because it is always pulling the first 50 results, you know an effective way to do it?
I know some, but it doesn't always workviniciuscastilh , I think it's necessary to go thru documentaiton of API from which you pull data.
