★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]
★ Check out the blog post ★
[ Ссылка ]
★ 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 ★
[ Ссылка ]
★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]
#MsExcel #PowerQuery
![](https://s2.save4k.ru/pic/qoKjJ10exUs/mqdefault.jpg)