Connect SharePoint File into Power Query
Importing a Excel file that is hosted on SharePoint or OneDrive should be as easy as copying the URL from the browser or when you use the share feature in SharePoint / OneDrive. Unfortunately, it's not so straightforward to get data from SharePoint. First, the URL link from the share feature isn't even the right one to use and then you have to be on the online version and request to open it with the desktop version to get the correct URL. After that it's just a copy and paste of an edited version of the URL to put into the Power Query field. It's sounds like a lot but once you see how it's done, it's not so bad. Hopefully Microsoft will make it easier in future Power Query updates. But in the meantime, check out the video to learn how to import a file hosted on SharePoint into Power Query.
🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p
🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF File to Excel
~-~~-~~~-~~-~