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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
seitwhertz
New Member

Connecting Sharepoint folder Error 405

Hey,

 

when trying to connect to a sharepoint folder

I get the error message :
We encountered an error while trying to connect.

Details: "Web.Contents failed to get contents from 'https://*******.sharepoint.com/sites/********/_api/web/lists/getbyid('********)/RenderListDataAsStream?cid=*******' (405): Method Not Allowed"


Accessing the sharepoint files is not an issue. They are part of an MS-Teams channel
There are subfolder in it, but that shouldnt be an issue, is it ?

1 ACCEPTED SOLUTION

Take the /:f/r out of the URL - that breaks it. It wants the "clean" version. 

View solution in original post

4 REPLIES 4
christinepayton
Super User
Super User

Subfolders are fine. Could you maybe copy your query from the advanced editor? The error doesn't look like something you'd get from the folder connector since it's querying a list by the ID (the folder connector gets all files in the site and lets you filter down). 

Hey, maybe I am doing it wrong. I am just the IT guy who has to troubleshoot this issue.

I opened the advanced editor, and tried adding a new source, choose sharepoint folder and copied the site URL
https://*******.sharepoint.com/:f:/r/sites/***********/

Then I get the error message I mentioned. Can I still see the query it tried using it ?

Take the /:f/r out of the URL - that breaks it. It wants the "clean" version. 

you're a hero. I would NEVER have figured this out!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors