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: [ Ссылка ]
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: [ Ссылка ]
🎦 Power Query Advanced Editor - What Is It & How to Use It?: [ Ссылка ]
🎦Power Query Error Handling - How to Deal with Power Query Errors Part 1: [ Ссылка ]
🎦 Refresh Breaks - Avoid the Column of the Table Wasn't Found Error & Dynamically Change Column Names: [ Ссылка ]
✅ 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:
☕[ Ссылка ]
✅ For more videos please subscribe:
🔔[ Ссылка ]
✅ Please also check out my Excel course on Udemy, please use this link:
📖 [ Ссылка ]
Ещё видео!