Forum Discussion
OneDrive Folder as source
Hi community,
I want to connect my onedrive folder and use all the files inide the folder as source. As many blogs and solutions from community recommends connecting onedrive via "Web" connector, I pasted my folder path to the URL and it shows error like
But when I connect the files directly, I can access the file using "Web" connector. But not the folder.
As I searched further, I can see many recommending using Sharepoint folder for connecting onedrive folder. I tried connecting the folder URL and gor the following error
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"
The solution connecting the onedrive to local and use folder connector will not feasiable for me.
I struck here and help is required. Thanks in Advance!
Regards
Fazil M
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.
11 Replies
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
Hi M0hamedFazil ,
If you want to use Sharepoint Folder connector, you need to use the Web URL of the sharepoint site. Please follow the next steps:
In the sharepoint, create a site:Put the folder into this site:
Click "Home" and copy the Web URL:
In Power BI Desktop, use sharepoint folder connector to connect:
After authenticating with your account, you can get the files in the folder:
Power Query SharePoint folder connector - Power Query | Microsoft Learn
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.Hi Anonymous
Actually I am using ondrive as source and not sharepoint itself. I tried using the web URL and it throws me error like
Regards
Fazil MHi 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.
