How to Fix Formula.Firewall Error in Power Query
You've created a query that picks up the source file from a cell in an Excel worksheet. This is to allow users to easily change the file that they want the query to address. You post the file with the query to a network location so others can use it. The queries run fine for you but whenever anyone else tries to refresh the query they get an error that states "Formula.Firewall Error: this query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. It’s Another Power Query error, that’s actually really easy to fix and I will show you exactly how in this video.
✍️Please download the practice file here: https://docs.google.com/spreadsheets/...
Timestamps:
00:00 The Formula.Firewall Error to Fix
00:55 The Key to Fixing the Error
02:01 Understanding How Queries Depend on Each Other
04:47 How to Fix the Formula.Firewall Error
✅ Please see link to videos mentioned in this video:
🎦 Create a Dynamic File Path - Change the Power Query Source Based on a Cell Value: • Create a Dynamic File Path - Change t...
🎦 Power Query Advanced Editor - What Is It & How to Use It?: • Getting Started with the Power Query ...
🎦Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to D...
🎦 Refresh Breaks - Avoid the Column of the Table Wasn't Found Error & Dynamically Change Column Names: • Refresh Breaks - Avoid the Column of ...
✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:
☕https://www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-fo...