Question on using a folder on one drive as a source for Power Query

[Stuart74]

Hello

I hope someone can help me.

I am trying to link to a folder on my one drive and combine the Excel files there. I have tried numerous ways to no success.

I have purposely blacked out my company name as this is a corporate account.

The path is the right one, I followed instructions from

link

I also tried this

Thank you for any help in advance.

Regards

Stuart

 

[James006]

Hi,

A very clear explanation designed by Mynda TREACY :

Get Data from OneDrive or SharePoint with Power Query

To get data from OneDrive or SharePoint with Power Query is not as straight forward as it should be, but this tutorial gives you the steps.

www.myonlinetraininghub.com

 

[Stuart74]

Thank you for this guide. It has helped answer my query.

Regards

Stuart

 

[James006]

Glad to hear you managed to solve your problem