7 METHODS to change source data location in Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy



★ Check out the blog post ★
https://exceloffthegrid.com/power-que...


★ About this video ★
Maybe you’ve built some queries in a test environment, and now it’s time to start using them for real. The obvious question arises: How to change source data location in Power Query?

0:00 Introduction
0:47 #1 Edit the source step
1:24 #2 Change the M code (formula bar)
1:45 #3 Change the M code (advanced editor)
2:09 #4 Data source settings
2:59 #5 Worksheet cell parameters
4:02 #6 Queries as parameters
4:34 #7 Power Query parameters
5:21 Conclusion


★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/


★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com

Twitter: Twitter: exceloffthegrid


#MsExcel #PowerQuery