Forum Discussion
trevorgermain
Advocate I
Advocate IToo many requests in Web.Contents. Can I share a request?
Hi, I am querying a web api using Web.Contents in a loop to get paged data. The Api has a throttled request limit of 300 requests per 10 minutes. {
"results": {
"timesheets": {...
I ended up writing a web api as an intermediary that caches responses in a Redis cache. It seems to work really well for this scenario.
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi trevorgermain,
By referencing the main query, I wind up making the paged Api calls 3x (one for each table). Ideally, I'd like to have the Api called only once, and populate my 3 tables without having to go back to the source. Is there any way to "cache" the Api requests, and reuse them as the source for multiple queries?
As far as I know, there isn't a way to do it currently.
Here is a good article about Referenced Queries And Caching In Power BI And Power Query, which could help you better understand this issue. :smileyhappy:
Regards
trevorgermainAdvocate I
Advocate II ended up writing a web api as an intermediary that caches responses in a Redis cache. It seems to work really well for this scenario.