How to change the source data connector in Power Query | Excel Off The Grid

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

★ Blog post ★
https://exceloffthegrid.com/change-so...

★ About this video ★
As organizational IT systems evolve, the Power Query solution you built might no longer use the right connector.

Common examples are local Excel workbooks now stored on SharePoint, or SQL databases replacing CSV files.

The good news is we don't need to rebuild our entire solution from scratch. Instead, we just need to make a few changes to the M code at the start of the query.

I know changing your M code can be daunting, but don't worry—it's not as hard as it might sound. I'll show you how in this video.

0:00 Introduction
0:46 Example
1:36 Backup
2:03 Switch point
2:47 Get better at Power Query
3:18 New connector
4:57 Blend queries
6:57 Deploy
7:52 Clean up
8:06 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:   / exceloffthegrid  

#MsExcel