Forum Discussion
Caching queries for re-use
Hi everybody, I created the following query structure The query module "importer" is base for further subsequent "linked" query modules and by doing so I exptected the excel file i...
Please see this article/video to explain what is going on.
Why Does Power BI Query My Data Source More Than Once? - Chris Webb's BI Blog (crossjoin.co.uk)
Pat
thanks.
It helped me, to understand the power query engine in this regard.
".....If you use Table.Buffer inside the Call Web Service query it will indeed buffer the result of the call to the web service into memory, but the data that is buffered cannot be shared between separate query executions..."
Unfortunately I wasn't able to find a solution for my problem
Use a dataflow or a "golden" dataset that implements your logic once.
