Power Query Drill Down and Formula.Firewall Error Explained

In this video, we look at how and why to use the Drill Down feature of Power Query, and how to solve the Formula.Firewall error. During the video, we import data from a website that is dependent upon the selection from a list in an Excel spreadsheet. The user can select a football league table from a cell drop-down list. And Power Query will fetch the chosen league table from the BBC website. This video delves a little deeper into the M-code of Power Query and is perfect for anybody who wants to understand it a little better. 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/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1