Forum Discussion
OneDrive Folder as source
Hi M0hamedFazil ,
You can copy the path of the folder in Onedrive and remove its suffix to your account:Delete from:
https://m365x96158828-my.sharepoint.com/personal/taojunyan_m365x96158828_onmicrosoft_com/Documents/excel%20folderto:
https://m365x96158828-my.sharepoint.com/personal/taojunyan_m365x96158828_onmicrosoft_com/Use sharepoint folder connector:
After authentication, you can access all the files in your Onedrive:
Click Transform Data and then filter in Power Query, filter Folder Path with the name of the folder you need to connect to.
And the final output is as below:
Note, however, that this is just an alternative, and there doesn't seem to be a way to connect directly to a folder in a particular Onedrive that I've tried (without using sharepoint)
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BeaBF hey!
The link I used is "https://domain-my.sharepoint.com/personal/fazilm_domain_com/Documents/folder1/"
Regards
Fazil MM0hamedFazil Ok. maybe that's why. You have to take the general link to sharepoint. If you click on the folder and do "copy link", you obtain a link like the one pasted by you. You have to open a file in that location in sharepoint online, then go to three points, details:
then scroll down, at the end of the lateral page, you'll find Path with copy function:
Copy it, you'll see that is quiet different than the first one. Try use it.
BBF
BeaBF
Actually, I copied the path of the folder from onedrive. when I copied the link of the folder it'll be like
"https://domain-my.sharepoint.com/:f:/r/personal/fazilm_domain_com/Documents/folder1/"
I tried both and didn't workout for meRegards
Fazil M
