Forum Discussion
Helper IError When connecting sharepoint folder to Power Bi
I get this error when trying to connect a SharePoint subfolder containing multiple CSV files.
The goal is to combine these files in PowerQuery. I can successfully connect to individual files, but not the entire folder.
"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)"
any help is appreciated, Thanks
2 Replies
- amitchandak
Super User
Tejinder , Make sure you have access to folder and it parent. seem like access to files only.
Hope you are using sharepoint folder option
Try this too
Go to home Tab -> Transform Data -> Data Source Setting
Clear Premission and try again
- christinepayton
Most Valuable Professional
Make sure your user account has read access to the site level, not just the specific folders or library. It uses the site-level permission to "get" all info about files in the site before you filter down to a folder.
