Power query from specific sharepoint folder

[wrooffy]

Hi all,

I am trying to query from a specific folder from sharepoint as follows, 

https://xxxxx.sharepoint.com/personal/steve_tanxxxxxxxxx/Documents/By Month/

However I am getting 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)"

I can however pull data from the root folder. 

https://xxxxx.sharepoint.com/personal/steve_tanxxxxxxxxx/

Any idea why this is happening? And how to resolve the issue?

[v-frfei-msft]

Hi @wrooffy ,

This document can help you to find the correct url you should use.

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

[wrooffy]

Hi @v-frfei-msft ,

Thanks for the reply. I am still having some issue accessing the folder. I am guessing it's some server side restriction. WIll try to figure it out. Thanks for your reply.