Forum Discussion
How to reference a query such a way, that it does not make multiple request towards web service?
I have a data source, which should be docomposed to several tables, so I created a query to make common processing and referenced (right click -> Reference) in the other queries with further processing.
However I noticed that this makes as many http GET requests, as there are queries, for the exact same information (and that is a problem because sometimes the server respondes with 500 internal error, probably due to the load it get from other sources as well). What am I doing wrong?
How can I instruct Web.Contents to retry those requests with 500 Internal Error?
3 Replies
v-ljerr-msftMicrosoft Employee
Hi Anonymous,
I don't think there is a solution with Power Query 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.
In addition, here is a similar thread in which a solution(writing a web api as an intermediary that caches responses in a Redis cache) is mentioned. Could you go to check if it helps in your scenario? :smileyhappy:
Regards
Hello v-ljerr-msft,
And what about other approches? Can I somehow handle record and list columns in DAX and use calculated tables?
You have forgotten the second link to the caching solution. Could you please edit your response?
Thanks,
Szabolcs
Hello v-ljerr-msft,
Would any of your suggested workarounds work with scheduled refresh in the Service? Ultimately that is the goal.
Br,
Szabolcs