Quickly Change Multiple Queries, Same Source in Power Query

If you've created multiple queries from the same source and then the location of that source changes, you'd think that you would need to go into each query and one by one change the source location. If there's a few queries, it not so bad. If it's a LOT of queries, that will be painful. You can actually use a parameter and then tweak some source settings to let you change the source location all in the same time. Plus at the end of the video I'll show a simple design choice that could be used to mitigate all this without using a parameter.

Extract Text in Power Query

When you have some values to pull out of a text or numerical string in a cell, you can use the extract commands in Power Query to make it easy. This is an great option to use instead of using the RIGHT, MID or LEFT functions in Excel or trying to split the value by some delimiter. It's so much more easier to pull the data into the Power Query editor and using Transform and Extract to pull your desired text string out.

Reverse a String of Text with Power Query

Reversing text or a string of text seems like something that is common task in software development either as a entry into how to perform this task by writing code instead of using built in function (or it's an interview question!). It seems to be an simple task but thinking it through and putting it into code is something that helps engineers think about how to write code elegantly. How does Excel help in this? By using it to already reverse the text output, you can use Excel to help validate the output of the code. And using Power Query, it's really easy to get this output. Check out the video to see how.