Forum Discussion
Solved
Referencing vs duplicating queries speed affect
Hi I have a fialy complex query pulling in form multiple sql tables (one for each client) then a whole bunch of formatting and cleaning tasks. This generates Table1. The table contains 3 differ...
Hi masplin
I would suggest using the second way.
As for the first way, you have to import this source four times totally even if you removed unnecessary columns. It is inefficient. If your source contains amount of data, it will take some time whether it is importing or refreshing.
I know this was marked as solved, but I think this artice provides a really good explanation and possible alternative solution if you need to manipulate the data they all have in common - Referencing Power Query queries - Power BI | Microsoft Learn
Thanks for linking the article. Was super helpful in clarifying. Forums seem to have a lot of folks giving 'expert' advice and hurting instead of helping.
