Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Tejinder
Helper I
Helper I

Error 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 2
christinepayton
Super User
Super User

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. 

amitchandak
Super User
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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.