Create a Dynamic File Path - Change the Power Query Source Based on a Cell Value

Описание: Learn how to create a dynamic file path in Excel to which your query will connect. Then all you need to do is update that file path in Excel and hit refresh and your query updates with the new file’s data! Watch this video to learn how to do this!

If you would like to download the workbook please use this link: https://drive.google.com/drive/folder...

00:00 The End Result
00:19 The Source Data Structure to Avoid Errors
01:21 Creating the Query
03:03 If Statement in Power Query
05:16 Creating the Dynamic File Path in an Excel Cell
07:35 Formula.Firewall Error in Power Query
07:55 How to Fix the Formula.Firewall Error in Power Query
09:31 Send ExcelFilePath Object Back to Excel

✅ Please see link to videos mentioned in this video:
🎦 Power Query Advanced Editor:    • Getting Started with the Power Query Advan...  
🎦 Power Query Custom Functions:    • Power Query Custom Functions - Easily Crea...  
🎦 Power Query VLOOKUP:    • 5 Ways to Use Merge in Power Query & Make ...  
🎦 Power Query Parameters:    • Power Query Parameters - Dynamically Chang...  

✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft

✅ 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  

✅ For more Power Query videos please use the links below:
🎦 Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data:    • Excel's Power Query: The Ultimate Beginner...  
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query:    • Power Query Age Analysis - Create an Excel...  
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1:    • Power Query Error Handling - How to Deal w...  

✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-fo...