Forum Discussion
API calls and parallel loading
Hi SanderVeeken
When parallel loading is enabled, it is not uncommon for Power Query to make multiple calls to the same API.
If you have multiple queries that reference the same source query, Power query might try to refresh each query in parallel, causing it to make multiple calls to the API at the same time.
This is because Power Query does not always recognize that the referenced queries are extracted from the same API call, and therefore treats them as separate data sources that can be loaded in parallel.
You can try the following steps to alleviate this problem:
Disable parallel loading: As you can see, turning off parallel loading prevents multiple simultaneous API calls.
Composite query: If possible, try to combine API calls into a single query and then reference the combined query in various tables. This way, Power Query will only need to make one API call.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The thing is that I'm already referencing the source queries. There are three separate API calls that can't be combined (one is "students", another is "courses", another is "teachers"). I get current season info from those API calls. I get previous season history from excel dumps on SharePoint. I append them to get a complete picture. I would have thought that using references prevents PQ from doing multiple requests to the same endpoint but apparently not.
You can try Binary.Buffer but even that does not shield reliably against the meta data chatter.
