Power Query Performance Optimization

  Рет қаралды 32,121

Paul Turley

Paul Turley

Күн бұрын

Пікірлер: 21
@stuartsaint4581
@stuartsaint4581 2 жыл бұрын
Great to see this. I'm a bit of an obsessive over tidying up my transforms into as few steps as possible. I didn't realise it had such a bearing on performance so I'm glad I have an additional, practical reason to so heavily optimise my transforms now!
@leerv.
@leerv. 3 ай бұрын
Not only that, but it looks much cleaner and professional and is easier to read the flow of steps when you don't have a lot of duplicate steps!!
@thirupathynatesan9323
@thirupathynatesan9323 3 жыл бұрын
Great learned useful Diagnostic test to see the process time for each steps of the query
@rjm50
@rjm50 3 жыл бұрын
Hi Paul. I'm running Office 365 and do not see the Tools menu at the top of the Power Query editor. Do you have any guidance, thanks.
@billybee
@billybee 4 жыл бұрын
thanks for this! I always group together similar M steps by instinct out of sheer borderline OCD. Apparently it's the way to go (or be)!
@tubez29
@tubez29 3 жыл бұрын
I noticed this too. Thank you. If you could expand on this topic, that will be great. For example, could you go back to a step and add more actions to itself. Is there a tool that would "look into your" power Query and "Optimize" it for you?. You could explore what actions are more time-consuming than others. For example, merging, vs filtering, vs replacing values.
@robroszk
@robroszk 3 жыл бұрын
The biggest issue i have in PowerQuery regarding flagged memory errors are when i need to use 'group by' for mass amounts of data and then un-'group by' to get the underlying line details back. Still have not been able to solve for this other than maybe order some more RAM memory to hopefully address this.
@joriszsz95
@joriszsz95 Жыл бұрын
I have the same problem. Did you solve this yet?
@gestiondecontrolsecretaria1236
@gestiondecontrolsecretaria1236 4 жыл бұрын
Thanks. I'd like to have more tutorials like these.
@mostafa-hussien-data
@mostafa-hussien-data Жыл бұрын
hi and thanks. i am wondering what to do about "Add Index" step that i use 2 times after one another, it takes too much time according to query diagnostics?
@HakeemLawrence-n4x
@HakeemLawrence-n4x 4 ай бұрын
Very nice video! Thanks
@chickenman7252
@chickenman7252 2 жыл бұрын
Cool I gotta redo all of my queries now
@VanshajSekhri
@VanshajSekhri 6 ай бұрын
It's really a Great Video!
@fernandotalvik3498
@fernandotalvik3498 4 жыл бұрын
Simple, but very helpful. Thanks
@danishsiddiqui6136
@danishsiddiqui6136 2 жыл бұрын
Thanks for details
@jamesrounce3043
@jamesrounce3043 4 жыл бұрын
Really helpful and well explained, thanks!
@_Areknames_
@_Areknames_ 3 жыл бұрын
Great! I have one question Paul : in therms of memory addressed , are all those steps treated by PowerBI as a sort of new variable each that never gets erased till the end of the steps? just asking would you suggest to lower the ram used by forcing reusing the same 2 or 3 'names' of variables/stepnames to load the dataset output of each step in fewer ram (just in case of many programs opened and less write to disk operation which may improve overall speed of execution?). Have you ever tested or had experience of improved performance as such? thank you
@diegoj9056
@diegoj9056 4 жыл бұрын
Thank you, great video. Already subscribed
@balrajvirdee1087
@balrajvirdee1087 3 жыл бұрын
Great tip thanks so much
@Unbox747
@Unbox747 3 жыл бұрын
Thank you!
@richardferretti8208
@richardferretti8208 2 ай бұрын
9mins just to tell us to consolidate our steps. I think you need to optimise your videos...
Power Query - Faster & Easier Parameters
13:38
BCTI
Рет қаралды 42 М.
The Dimensional Dilemma and Power BI
19:35
Paul Turley
Рет қаралды 8 М.
Каха и дочка
00:28
К-Media
Рет қаралды 2,7 МЛН
Debugging a slow Power BI report with Phil Seamark
13:01
Guy in a Cube
Рет қаралды 71 М.
Optimizing time intelligence in DirectQuery
18:09
SQLBI
Рет қаралды 6 М.
25 Amazing Power Query Tips and Tricks
32:03
How To Excel
Рет қаралды 90 М.
Power Query - List.Buffer to do a Million row Lookup
6:53
BA Sensei
Рет қаралды 10 М.
5 Best Practices in Power Query
11:31
Goodly
Рет қаралды 52 М.
APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query
7:41
ِAAA Excel English
Рет қаралды 5 М.
2 Power Query Refresh Secrets Everyone Should Know!
6:35
Miss Microsoft
Рет қаралды 21 М.
Refreshing twice in Power Query in Excel? Why? Fix it now.
30:34
Celia Alves - Solve & Excel
Рет қаралды 7 М.