I am a powerbi developer. my company has many organizations under their name and each organization have many repos (around 300+).

I was able to write 4 tables in power query powerbi
Table 1. Get all organization and repo names.

I will use table 1 as reference to my next 3 table so I don’t call the same code twice to get repos.

Table 2. Get issues of all states for each repo.
Table 3. Get pulls of all states for each repo.
Table 4. Get commits for each repo.

however, the data can never fully load because I always hit the 5000-rate limit hourly even though i limited the data since 2 months ago only.

is there a workaround? I am not abusing the Api for web scarping I want to analyse the performance of our developers. like maybe a custom connector, a different approach. i prefer keeping things free

i tried limiting dates, i tried reading GraphQL but i have no idea how to translate it to powerquery and i am no computer science guru. i only know python and m query as programming languages.