Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
@Siboska You can create a dataflow and in the dataflow turn on Enhanced Compute Engine.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!