Power query from specific sharepoint folder

Anonymous · ‎07-21-2019

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 · ‎07-21-2019

Hi @Anonymous ,

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/

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Anonymous · ‎07-26-2019

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.