The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 ?
Solved! Go to Solution.
Take the /:f/r out of the URL - that breaks it. It wants the "clean" version.
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!