OneDrive Folder as source

[M0hamedFazil]

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

[Anonymous]

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.

[M0hamedFazil]

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 M

[Anonymous · Accepted solution]

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%20folder

to:

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.

[K_S_C]

I have filtered the correct folder, and I can see the included files. So I'm at the point that I can see those files but as a list of binary files. The thing is that I want to keep them as separate files and I can't figure out how to do that.

[M0hamedFazil]

Hi @Anonymous 

Thanks for the reply and I this works perfectly. I too tried many other ways and ended up using this. I used this currently and moving on. Thank you so much for the time.

Regards
Fazil M

[BeaBF]

@M0hamedFazil Hi! Can you share the link to which are u trying to connect?

BBF

[M0hamedFazil]

@BeaBF hey!

The link I used is "https://domain-my.sharepoint.com/personal/fazilm_domain_com/Documents/folder1/"

Regards
Fazil M

[BeaBF]

@M0hamedFazil 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

[M0hamedFazil]

@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 me

Regards

Fazil M

[BeaBF]

@M0hamedFazil have you tried with the method above? on one file in the folder, not the folder.

BBF

[M0hamedFazil]

@BeaBF , Hey

As I mentioned in the post this is working for file directly but not for folder.

Regards
Fazil M