Forum Discussion
Power query from specific sharepoint folder
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?
2 Replies
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/
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.
