Power Query connect to OneDrive Personal files | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Read the blog post ★

★ About this video ★
Getting data from OneDrive Personal using Power Query is a little tricky. But don't worry, I'll show you how 😀

0:00 Introduction
0:20 Where to find the URL
1:17 Warning about file sharing
1:47 Edit the HTML code
2:50 Connecting to Power Query
3:47 Updating the data
4:27 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #PowerQuery

[fernandomonfort]

Un-freaking-believable!! Thanks for this huge tip! I didn't expect to find it anywhere, to be honest...

[lptyger]

Wow! Did not expect to find my answer on a video with only 900 views from 4 months ago.

Obviously, Microsoft has the ability to implement this directly into Excel, but gotta do what we gotta do. Thanks much!

[lucas]

Impressive how precise this video was to what I needed. A while ago I followed it and it worked perfectly. Recently, I tried to update my worksheet and noticed the connections failing. After some trials, decided to start from scratch, came back here and noticed that the link from Onedrive has changed completely, and the error message says: "DataSource.Error: The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server." Not sure if there is a solution for that.

[TheSTEPHEN]

Sir you really saved my day, i have been searching everywhere, but unaware we need to use the embed link. thank you very much. =)

[wayneedmondson]

Awesome Mark! Nice to know how to do this, even if more complicated than it should be. Thanks for sharing! Thumbs up!!

[phanxuantan]

That's so beautiful solution I had been looking for long time ago. Thank you very much, Mark!

[jasontan]

Thanks Mark! I been searching for this solution for weeks & glad to find your video 👍 However I also need to load files inside a Folder from OneDrive Personal & unable to find workable solution. Appreciate if u could shed some light here. Thanks Mark

[tracykirkman]

Thank you, great info. Do you know how to link to a folder on OneDrive Personal, since I have many files in a folder connecting to Power Query to create many queries for one visualisation dashboard. Trying to embed and link each file separately is going to take forever, plus what happens when I add new data as a new file? Thanks

[wtotino]

Thanks a lot
What about getting data from an entire personal OneDrive folder ?
Not only a single file

[Chillman]

Hi! This is very cool! Can this be done for entire folder in which there is the Excel file (not only specific Excel file)?

[nivedita]

Thanks Mark. Is there a way to get data from One Drive folder. I tried the same steps for a folder but it didn't work.

[keerthy.shunmugarajan]

Hi, When I followed through your tutorials, I see the URL that I have is encrypted. It doesn't look similar to yours. Is there a work around?

[philip]

Is this still working? Can’t get this solution to work for me

[afauzir]

It is not working anymore since Microsoft updated the link structure, anyone have solution?

[CeliaAlvesSolveExcel]

It should be easier... it is easier to connect to a Google Sheets file than to a Microsoft's file...🙄