Forum Discussion
Loading every workbook inside a folder using one main file on Sharepoint
Otherwise it doesn't work. Your URL to connect is
https://COMPANYNAME.sharepoint.com/sites/odms
Transform returned and in Power Query editor you shall filter this column
to keep only needed folder.
Thank you for your response.
I'm trying but the root of the sharepoint folder doesnt yield the results I want.
The folders are in Shared Documents folder. Could that be the issue?
The URL of the folder I want to access to is as below but excel doesn't accept it.
https://COMPANYNAME.sharepoint.com/sites/odms/PROJECTNAME/PROJECTNAMECITYts/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2Fodms%2PROJECTNAME%2FPROJECTNAMECITYtsts%2FShared%20Documents%2FBusiness%20Planning%20%2D%20Account%20Planning%2F3%2E%20Resource%20Planning&viewid=37aeaabe%2Dbe64%2D4881%2Db5db%2D01fbadf9afec
Otherwise it doesn't work. Your URL to connect is
https://COMPANYNAME.sharepoint.com/sites/odms
Transform returned and in Power Query editor you shall filter this column
to keep only needed folder.
- Thank you!!!! It worked.
kheldar , glad to help