25 Amazing Power Query Tips and Tricks

[@HowToExcelBlog]

Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/

[@billgillaspey9036]

Great review! I would suggest adding: if one is deleting a lot of steps, first *duplicate* the query...just in case. That way, one has a copy of all the query steps. Maybe one deletes more steps than they needed to delete, for instance.

[@wayneedmondson1065]

Hi John. Just found this gem from a few years ago. Great collection of PQ tips! Picked up a few I had not seen prior. Thanks for sharing :)) Thumbs up!!

[@michaelkrailo5725]

No idea why there isn't more hits on this video, very good practical knowledge to know about power query. I needed to know how to transfer query to a new workbook and you had the solution near the end of the tips. The problem I had though, is the copied query just shows up as an empty table! Why is that.

[@rjbjajjjmj1]

This was a terrific find for me today... I'm now a subscriber based on this video.

[@zvikabar-kochva3641]

Thanks man. Very useful information. You may consider unchecking "Allow data preview to download in the background" in the Query Options, under Current Workbook, which in my experience and others is one of the greatest factors speeding up query loads.

[@HowToExcelBlog]

Thanks for the tip!

[@txreal2]

nice & quick w/ examples and list to remember (no lengthy explanations like other videos), will subscribe, thanks!

[@reanalytics1863]

Appreciated I have picked up a good number of tips and tricks to apply in my daily work

[@mutlunun]

Watch in x1.5 speed :) But the tips are really good, thank you.

[@Monika-hx9ke]

thank you for a clear overview. Looking forward to some other selections.

[@HowToExcelBlog]

Thanks Monika! Glad you enjoyed it.

[@timmytesla9655]

Great tips. I learnt a lot. Thank you.

[@centurychallenger]

15:24 - thank you for tip on Case sensitive issue in filtering

[@HowToExcelBlog]

Yes, it will save some headaches 😉

[@gborka]

Thanks a lot, "must have" tips list for beginners and intermediate users.

[@kennethstephani692]

Great video!

[@jesseaugusto6587]

So many useful tips! Thank you!

[@HowToExcelBlog]

You're welcome. Hope they help.

[@kebincui]

Very clear and useful info. Thank you very much for sharing

[@garrylingle741]

Thanks for the great video. I've watched it twice so far and will definitely watch it again. I really liked the section about adding comments in the formula bar. I played around with that and found that if the entire statement is enclosed in parentheses, the comment can be added to the end of the statement and still be retained in the formula bar. See the sample below. = (Csv.Document(File.Contents("C:\WeatherLink 54\download.log"),null,{0, 1, 17},null,1252) /*test */)

[@HowToExcelBlog]

Thanks Garry!

[@HowToExcelBlog]

And thanks for the great tip on comments!

[@felipedeamorimcarvalho8750]

Very cool!!!! There is one thing that I don't find anywhere.. how to tell power query to always import the 6 first columns of an excel file? If I format the data as the table it works, but if I don't do that sometimes I will find 5 columns sometimes it will find 6 ...

[@Luciano_mp]

Valuable tips, excellent tutorial. Thank you!

[@kennethstephani692]

Excellent Video!

[@HowToExcelBlog]

Thanks!

[@colinchiu7113]

Amazing!

[@johnabram4159]

@ 13:18 great trick on tackling case-sensitivity.

[@mmincredible1451]

✨Bravo man love from india...

[@HowToExcelBlog]

Thanks!

[@malchicken]

Much appreciated. Particularly liked #shared and previous steps as new query. Please consider a video on tips for query referencing best practices. I’ve found myself lost in tables and queries and what’s in the data model and where corrections need to be made after a couple queries in @.@

[@Phoenixspin]

This man deserves a Nobel Prize.

[@HowToExcelBlog]

And the Nobel prize in power query goes to... 😂

[@evaskalova7903]

Very helpful, thank you! These tips are so useful and practical!

[@divyakhare9079]

Thanks for keeping explanation short and sweet☺ Very Nice!

[@bobdanilop]

Well done, very useful!

[@HowToExcelBlog]

Thank you!

[@giancarloariassilva7661]

These little details are helpful. Thanks.

[@HowToExcelBlog]

No problem!

[@mikelennon1078]

What is the best way to update the records in the source table/sheet form the Power Query ( like, adding records, deleting a record, editing,.....). Can we make a column properties ( one or more columns) a Hyperlink that be clicking it, a custom data entry form be opened to add, deleted or update the record/s in the source tables?

[@HowToExcelBlog]

You could use power automate with the Excel selected row trigger.

[@mikelennon1078]

@@HowToExcelBlog Not sure if I follow. Would you be able to elaborate or give an example please?

[@ExcelSquad]

You are seriously awesome .Thank you so much. Please make a video writing a formula on powerquery

[@HowToExcelBlog]

Do you mean writing a custom query function?

[@ExcelSquad]

@@HowToExcelBlog yes please make a custom query sorry for using the wrong term.

[@HowToExcelBlog]

It's already done. Check out my bulk find and replace video and my replicate Excel trim function video.

[@HowToExcelBlog]

kzbin.info/www/bejne/mIKwdqeerdKXnZY

[@HowToExcelBlog]

kzbin.info/www/bejne/poKQd2mahtxjr8k

[@ynwtint]

= #share which I learnt the best tips.. and Drilldown (single value) usage is very useful in %of(something) scenario. Thanks for sharing.

[@obasisamson7528]

Its Awesome...thanks

[@HowToExcelBlog]

🙂

[@SanjayVijayanand]

Superb

[@Omarw100]

Very useful info. Thank you!

[@FRANKWHITE1996]

Thanks

[@HowToExcelBlog]

You're welcome 👍

[@pedrogentico1716]

Very useful indeed

[@johnborg6005]

Great Tricks !!! :)

[@HowToExcelBlog]

John Borg thanks!

[@FriendsOfChildhood-Pakko]

watch in 1.3x speed, You're welcome :)

[@danialamin252]

ctrl+shift to select the complete row

[@HowToExcelBlog]

Yes, there are a couple Excel shortcuts that transfer over 😀

[@eastwezt7928]

ASTERISK

[@powerbinareal]

TOP!#powerbinareal