How to make dynamic the path to the data source files in Power Query in Excel | L0027

There are situations where the path to the data source for a query built with Power Query in Excel needs to be adjusted based on certain conditions. It may be because you want the query to look into a different file or folder, or it also could be that you are working on a shared folder (with Dropbox, for example), and you need Power Query to adjust the path based on the user's name. There are several ways to solve these challenges. In this session, I will teach my preferred method.
________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________
---
Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn:   / celiajordaoalves  
Facebook:   / solveandexcel  
Twitter: @celia_excel
Instagram: @solveandexcel
YouTube: https:www//   / celiaalvessolveexcel