Скачать с ютуб Create a Dynamic File Path - Change the Power Query Source Based on a Cell Value в хорошем качестве

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...