Optimizing Pivot operation in Power Query
Рет қаралды 3,637
3 жыл бұрынConsidering that classic Pivot operation has a really slow performance when working on large data tables, we introduce you a new trick on how to potentially optimize Pivot operation in Power Query.
For any questions, comment down below!
To learn more about Power Query, check out our Power Query fundamentals course!
exceed.hr/en/academy/powerque...
#powerquery #powerbi #etltools #data #dataanalysis
@user-gc8wx2ni8w
Fantastic! It does cut the refresh time by a lot!
@datawizibility 12 сағат бұрын
Loved it...thanks a lot for all wonderful videos...
@MrApoloni13 2 жыл бұрын
well done. Respect! appreciate your effort. i am learning many things from your channel. thanks for support us
@herivelto.cordeiro Жыл бұрын
Hi @Exceed Learning! I have tried this trick with my dataset but I got worst performance. I have a table with more than 50 millions rows and would like to pivot a column with 80 distinct values. Any suggestion?
@larmondoflairallen4705 2 жыл бұрын
How did you learn about the underscore and all the transformations you can do with it? You do some really interesting code manipulations that I haven't seen anywhere else.
@qasimjan5258 2 жыл бұрын
Sir could you do power query M series from basics. Thanks
@malchicken 2 жыл бұрын
Informative, thanks :)
@drewbbc7074 2 жыл бұрын
Brilliant
@Mister_Bates Жыл бұрын
Great tip! One question. At this point
超人夫妇
Рет қаралды 27 МЛН
Excel Off The Grid
Рет қаралды 7 М.
Leila Gharani
Рет қаралды 351 М.