Power Query connect to OneDrive and SharePoint | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Read the blog post ★ https://exceloffthegrid.com/power-que... ★ About this video ★ In Power Query, when we connect to a local file, it's reasonably obvious how we do that; it's built directly into the UI. We just need to navigate to the location... Bam. Done! However, what about when we want Power Query to connect to a file in SharePoint or OneDrive, how do we do that? It's not obvious. Actually, sometimes what seems like the answer can lead us down the wrong file path. So, in this video, I want to show you how to connect to OneDrive or SharePoint with Power Query. 0:00 Introduction 0:59 Where NOT to find the URL 2:52 Where to find the URL 4:42 Connecting to a folder 5:53 Summary ★ 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 #PowerQuery