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

I do not understand why Microsoft doesn't just allow us to point directly to the folder we have a gazillion files in our SharePoint, I am trying to filter to the folder but the query is not finding it, I have copied and pasted the exact path but still no go, is there any other way to reference the folder.

It’s really very helpful for me, thank you so much for this, i got exactly what I’m looking for. 👍

Thank you! clear and to the point as always

HI, this is amazing, thank you. Neeed a small help please. One of my team members is not able to sign in thru share point, to run the query. He is missing the organizational account option, no one has been able to help us. Anything you can think off to help us

Thank you ... I needed to watch only the first 2 minutes to find what I was trying to do in the last 2 hours...

You are awesome! THank you!

Great Video. But I don't have Sharepoint Folder On Microsoft 365. What should I do ?

This is great. I'm trying to link to a sharepoint folder but when I click File, there is no option for Sharepoint folder. Any idea what the problem is?

Hello, great info but what about 365 business users , seems like Microsoft left out the SharePoint connector out , is there any work around? Thanks

Super helpful. Thanks very much Genius

Hi Mynda. Previously I gave up getting data from "SharePoint > from folder" as it takes a long time to even filter the required folder location from power query. So I just chose to get data from my OneDrive as it works faster. However, it limits to just myself to refresh the data. I've re-watched this video getting data from SharePoint and have learned that I'm filtering the folder incorrectly before. I need to have my team refresh it aside from myself so I need to connect it from SharePoint. However it takes a very long time to refresh the query. Do you know why? Thanks.

This is exactly what I was looking to learn how to do. Thank you.

what a life saver, can't believe is 2023 and there is no easy way to connect to sharepoint on office business standard, how do you come across this workarounds

wonderful thanks a lot

Mynda this video was perfect. Why Microsoft have decided to make OneDrive/SharePoint cloud integration into a key selling point feature such as Power Query so difficult and fiddly we can only imagine - hopefully the process becomes streamlined because even now after your excellent tutorial it is a daft amount of work when the On Premise solution is generally faultless.

how do i change the data source from local path to onedrive shared folder with me

Hi Mynda, may I check if possible to get data if my files are saved on company's intranet? Thanks in advance

Hi, My excel doesn't have from share point folder option. How to enable it? Please help.

Do you have a similar video to get data from Dropbox?