Create a Dynamic File Path from SharePoint & Change the Power Query Source Based on an Excel Cell
Learn how to create a dynamic file path from a file located in SharePoint to an Excel cell 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:21 The Source Data Structure
01:14 How to Get SharePoint File Path & Connect to Power Query
02:22 Creating the Query
03:31 Create the Dynamic File Path
✅ Please see link to videos mentioned in this video:
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to Deal w...
🎦 Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value: • Power Query Parameters - Dynamically Chang...
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analysis - Create an Excel...
✅ 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...