Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |