I have written about changing Power Query sources before ( Power Query: Change the Source Data Location).
Wouldn’t it be better if the source could be linked to a cell value that we, or a client, could easily update? Yes, it would! So, in this post, we’re going to look at how to do that how to change the Power Query source based on a cell value. Or maybe you’re a consultant who creates solutions for others when you distribute the workbook to your client, you have to provide them with complicated instructions on how to update the data sources for their environment. This means the paths of all source files must be updated. If you’re like me, you build Power Query solutions in a test environment first then, when ready, it’s released into the wild.
