5 Power Query GOTCHAS - Solving 5 Common Power Query Mistakes

In this video, we look at 5 common Power Query mistakes, or GOTCHAS, and show some possible solutions to them. Excel Power Query is brilliant, but there are some GOTCHAS waiting catch unsuspecting users, in-fact some of them catch regular users also. Check out the common mistakes. Do you have any to add? Please do so in the comments. Video timings. 00:00 - Power Query mistakes introduction 00:38 - Power Query is case-sensitive 04:33 - The order of column selection 06:36 - Autocomplete with Tab 08:25 - Rounding issue in Power Query 11:46 - Automatic changed type step Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1