Forum Discussion
Using Source of one query for another
Yes, absolutely.
- Do your initial import of the view and any transformations you want. You don't have to do any, but you might want everything to be filtered for the last 2 years for example. Do that here so you don't have do that 4 times in the next step.
- Right-click on that query and select REFERENCE. That will make query 1 the source of query 2. Any changes to 1 will affect 2 (and 3, 4, 5.)
Do not select DUPLICATE. That will copy the first query and changes made in 1 will no longer affect 2. You might want that for other scenarios, but it doesn't sound like you do for this question.
HI edhans , amitchandak
I adapted my report again with Reference and disabled the load.
I see the performance has increased, but I can check on Monday morning. I will keep you posted.
Thanks a lot for your help!
Hi vikkidurai91 ,
as far as I know, you should deactivate parallel loading in the options so that the queries uses the cache.
There are good contributions from Chris Webb.
https://blog.crossjoin.co.uk/2016/11/20/referenced-queries-and-caching-in-power-bi-and-power-query/
edhans Thanks for your suggestion. We tested for last 2 days and Reference feature has solved the issue.
Thanks all for the help.
Excellent vikkidurai91 . Glad my suggestion helped and it is helping your project move forward!