How to reference a query such a way, that it does not make multiple request towards web service?

[Anonymous]

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?

[v-ljerr-msft]

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? 

Regards

[Anonymous]

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

[Anonymous]

Hello @v-ljerr-msft,

Would any of your suggested workarounds work with scheduled refresh in the Service? Ultimately that is the goal.

Br,

Szabolcs