Get Data From SharePoint or OneDrive with Power Query - Demystified!

In this video I cover the 3 options for getting data from SharePoint or OneDrive with Power Query:

00:27 From a Single File on SharePoint or OneDrive
04:08 From a SharePoint or OneDrive Folder
08:12 From a SharePoint Shared Library
11:56 Sharing Files with Others

Note: The SharePoint Folder connector is only available in Excel 2019 Professional Plus and with a Microsoft 365 Apps for Enterprise license

[markusdurm]

You are my heroine, that I searched for long time and no one at work had a clue.

[aryaa]

This is amazing, thank you for sharing! I have to say you make an excellent teacher. Very natural, coherent, interesting, correct pacing, nice voice, confident, intelligent and so on. I sound incredibly boring when presenting XD

[martinargimon]

Hi mYnda, I have revisited this video of yours one again, as more and more, we are all using a cloud service ( onedrive in my case). You are definitively one of the best instructors and your knowledge is excellent. I wish you the best in your business and many thanks for helping us, in this ever increasing complicated world of IT. Kind Regards. Martin

[llagarto]

Lots of tutorials, none as simple and easy to follow like yours. Thanks a lot!

[loolasim]

This was baffling me for several days. on google there were so many confusing codes, but your video showed a much clearer and (comparatively) simpler way. this was really helpful, thank you so much!!

[joshuaerkman]

I wish I had seen this earlier! I spent nearly 100 hours, developing a naive Bayes classifier to solve a particularly tricky identity problem, to determine the proper primary key in a database. This would have been so helpful for my methodology. Awesome to see someone else using Excel for this!

[IvanCortinas_ES]

Power Query and SharePoint. Relax and action! What a powerful tool!! Thank you Mynda.

[craigjohnwatson]

Thank you, a very clear and easy to follow video which solved my challenge (changing the data source to the company's Sharepoint directory). I was even able to adapt Option 1 to work with CSV files too.

[javiercalderon]

This tutorial saved my job!! I don't have enough words to say THANK YOU SO SO MUCH!!! You have blessed my life 😇

[Mahmoud-mfhn]

I cant thank you enough for what you are doing!
You are really helping us raising the bar!

[martinsefelin]

Really amazing! I can’t wait to try this! Been battling with SharePoint/ MS excel communication friendship for a while now. Seems like fun weekend is coming up😂. Love your content and thanx for helping me to be a better excel nerd 😀 Much Love! Martin

[DiamondRock]

Thank you Mynda, Power Query is a very important tool and you make this tool easy to use step by step. We appreciate your effort.

[Ernestofranco]

The way you walk through this is amazing. So simple and I just need to find you when I get stuck. Every answer I find through you. Thank you so much

[mat]

You provide a tremendous service. This video enabled access to the centralized data files by my MS Teams members---and saved the day. Thank you.

[BaneIsAlive]

I was trying to figure this out for a week until i came across your video. Youre a life saver.

[RanjitKumar-brff]

crisp, clear and to the point. Much appreciated

[jorgevalentin]

What an amazing video, simple and intuitive. Thank you so much!

[miguelmr]

Thank you Mynda, I always wanted to perform PQ with a Teams shared file and I didn't know how. With your explanation in this video, I have solved it. This advice is very useful for me. Thank you

[rafaelboschetti]

Awesome! I've been using power query for years now and I just did not understand how to make the connection work by reading some tutorials online, you made it really simple. Thank you so much!

[zakincc]

You’ve been a great help in making me learn and improving my productivity. Thank you so much ❤️