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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors