Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Sharepoint - Unable to connect error

Hi everyone


I am trying to connect from Desktop to an Excel file in Sharepoint for the 1st time, so I entered the url including the site name but I get this error:

 

"Unable to connect

We encountered an error while trying to connect.

Detals: "Web.Contents failed to get contents from 'https://abc.sharepoint.com/sites/105066/_api/web/lists/getbyid ('fba6e538/22b7'-etc)/RenderListDataAsStream?CID=41a779e9-etc' (405) Method Not Allowed"

 

Can anyone help please ? thanks

Need Help
  • christinepayton's avatar
    christinepayton
    2 years ago

    If you are connecting to a single file, the easiest way to swap from desktop to SP is to copy the path for the file, not using the root site/folder connector. There's like 9 ways to get a link to a SP file, and only one of them will be the correct path - you want the one in the "more details" of the file properties. I have a how-to on this here if it helps: https://youtu.be/2HZ8l23RXnc

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi Anonymous , 

    The link should have an ?SOMETHING at the end you need to delete everything after that ? and should work.


    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks but I tried that but it did not work.

      When I use the base url abc.sharepoint.com it connects but I just see this

      instead of a list of folders/files.......how can I navigate to the folder which contains the Excel file I need ?

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    If you are connecting to a single file, the easiest way to swap from desktop to SP is to copy the path for the file, not using the root site/folder connector. There's like 9 ways to get a link to a SP file, and only one of them will be the correct path - you want the one in the "more details" of the file properties. I have a how-to on this here if it helps: https://youtu.be/2HZ8l23RXnc

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

     

    It seems you didn't use the correct connector or enter a valid URL with the correct format.

     

    If you want to connect to a single Excel file stored in Sharepoint online, copy its link from Sharepoint online and use Get data > Web in Power BI Desktop. It's similar to connect to an Excel file stored in OneDrive for Business. 

    Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.