repeat consult

[viniciuscastilh]

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

[AlB · Accepted solution]

@viniciuscastilh 

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 

[AlB]

Hi @viniciuscastilh 

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 

[viniciuscastilh]

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 work

[CNENFRNL]

@viniciuscastilh , I think it's necessary to go thru documentaiton of API from which you pull data.