5 tips to work faster in Power Query

In this video, I will show you 5 tips to work faster in Power Query!

Which one is your favorite? Do you have any productivity tip you want to share?

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter: @curbalen, @ruthpozuelo

[sandip_bettereveryday]

"Remove Other Columns" can be used to reorder columns even when you have no column to remove. Say, I have Col1, Col2, Col3. Then I will click, say, Col3, then Col1 and finally Col2 (while pressing Ctrl key) and then right click - choose Remove Other Columns. The result will now be Col3, Col1 and Col2 - reordered nicely. And the M code behind this step is also very interesting. Thanks.

[brunof.s.]

the "delete until the end" is a fantastic trick, thank you!

[tanababa]

I was not aware of the "Delete Steps to the end"...sweet :-)
Thanks Ruth

[austinleedavis]

"Remove other columns" Very nice! Thanks for the video

[HachiAdachi]

ooh, I wish I had known #2 earlier! I could have saved so much time by NOT having to (click 'x'), "Are you sure you want to delete this step?...", (click 'delete'), (click 'x'), "Are you sure you want to delete this step?...", (click 'delete'), (click 'x'), "Are you sure you want to delete this step?...", (click 'delete')...

[learnspreadsheets]

I knew these but cool still great! Click cell first before replace values to get those prefilled data. Multi select columns then change data type, use unpivot only selected and beef up the quick access toolbar!

[Chris_in_fremantle]

Great tips, really like the copy query tip. THX.

[edwinruizcolon]

Any tips to make the actual process run faster? I have a file with 7 sheets and is taking some times over 10 minutes to update?

[josepromero]

Fantastic, Ruth!!!
According this video, seems my PQ level is not so bad... :-))
You can also hide the ribbon by clicking CTRL+F1 as the rest of office applications.
Thanks a lot!
Josep.

[denmarkpowerbiusergroup]

Hi Ruth - Great tips - my best tip is to add a blank query and in the formula bar type =#shared - and you have a list of all the functions/types in Power Query /Erik

[Antoniohdz]

Is there any difference to work with data in powerpivot from access using power query???

[rrrprogram]

I knew all these... Yeeee... I am updated

[rassten]

Compared to the other comments, I'm not afraid to admit 1 + 2 + 4 + 5 is new to me, 3 I only know because Ruth has mentioned it earlier.

[mathew]

Your last 2 where new to me, thanks for your tips :-)

[mehdihammadi]

Hi Ruth, this time I knew 5/5 and guess why? Because I just reviewed, this morning, a post from John MacDougall published on june 2018 that include these tips and few others :). And like 'Josep said' seems my PQ level is not so bad :-))

[築夢者-wo]

The fifth tip, rename columns is a dangerous step which may cause a lot of errors if you want to refresh data source.
It should be handle by some more flexible m functions to avoid subsequent steps reference to the wrong column name since it is renamed.