Bad performance when referencing main table

[Siboska]

Hi, 

I have some performance issues for 5 tables in my datamodel. The tables will approximitly take around 30-40 minutes to refresh. 
For comparison the same table in SQL take appr. 1:30 min to execute. 

The case:
My main table is initiative. I make a reference to 4 other tables, where my hope was that it would only run the query once. In SQL, however, I can see that the query from my initiative is run 1 time for each table, which is very ineffective. NOTE ( All 5 tables must be used in the reporting and therefore refreshed):

As you can see in the following SQL snapshot the main initiative query is performed 5 times synchronously:

Is there a way in Power Query where I can ensure that when I create a reference table it does not run the main query again but uses the one that is run initiatives?
Or maybe there are other more efficient ways to do this type of task in power query?

[AntrikshSharma]

@Siboska You can create a dataflow and in the dataflow turn on Enhanced Compute Engine.

[Siboska · Accepted solution]

Hi Antriks, 

Thx for your reply. Interresting approach. I have never worked with dataflow tho so my solution was to rewrtite the logic in the referenced queries, so they have theire own native query only containing the relevant information. Got a significant performance boost.