Forum Discussion
repeat consult
Hi
I need to repeat the query N times
In this case, it is a simple query that gives me 50 results, and when I run it again it gives me 50 more results How can I add these results, for example be 3000 results and I can pull the 3000
It would be like doing this query several times and I save all the results, of course stipulate how many times I would need to repeat
let
Fonte = Json.Document(Web.Contents("-----", [Headers=[Authorization="Bearer -----"]])),
results = Fonte[results],
#"Convertido para Tabela" = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Convertido para Tabela"
Thanks
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
4 Replies
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.
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
