Forum Discussion

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago
Solved

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, ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

M0hamedFazil's avatar
M0hamedFazil
Icon for Helper II rankHelper II
1 year ago

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's avatar
Anonymous
Not applicable
1 year ago

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.

  • M0hamedFazil's avatar
    M0hamedFazil
    Icon for Helper II rankHelper II
    1 year ago

    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

  • K_S_C's avatar
    K_S_C
    New Member
    1 year ago

    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.