Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
viniciuscastilh
Frequent Visitor

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

1 ACCEPTED SOLUTION
AlB
Super User
Super User

@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 

SU18_powerbi_badge

View solution in original post

4 REPLIES 4
AlB
Super User
Super User

@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 

SU18_powerbi_badge

AlB
Super User
Super User

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 

 

SU18_powerbi_badge

 

 

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

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


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors