Forum Discussion

raphaelras's avatar
raphaelras
Frequent Visitor
5 years ago
Solved

Error when using the sharepoint connector.

I have been trying to get an excel that is located in a folder within a team site on sharepoint.

 

 

However, when I perform authentication through the Microsoft account, the following error appears.

 

 

 

I am the team administrator and I still haven't found the solution for this error in Portuguese or English. Could you help me?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi raphaelras 

    If you want to get excel from sharepoint , you can use Web connector .

    a)Sign in SharePoint with your account .And search your site .

    b)Right-click the excel you want to use, and select Open in App.

    c)In Excel ,select Info and click the Copy link to clipboard to copy the URL.

    d)Select Get Data >Web ,And enter the URL without “?web=1”

    (e)Then Sign in with your account ,and Connect .You will see the excel from sharepoint .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi raphaelras 

    If you want to get excel from sharepoint , you can use Web connector .

    a)Sign in SharePoint with your account .And search your site .

    b)Right-click the excel you want to use, and select Open in App.

    c)In Excel ,select Info and click the Copy link to clipboard to copy the URL.

    d)Select Get Data >Web ,And enter the URL without “?web=1”

    (e)Then Sign in with your account ,and Connect .You will see the excel from sharepoint .

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey raphaelras ,

     

    I'm a little confused about your link. A Sharepoint folder should start like:

    https://myCompany.sharepoint.com/sites/myTeam/

     

    Then make sure to load the base URL like posted above as "Sharepoint Folder". That should usually work.

     

    To be honest, I've never seen a link with "teams" after the main domain. Maybe check that again

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • raphaelras's avatar
      raphaelras
      Frequent Visitor
      5 years ago

      I already tried to access with "sites" after the main domain and it still doesn't work.
      The link with "teams" is used to access, because the sharepoint is the repository of a team created in Microsoft Teams.

       

      I will also try the same link with the other 2 Sharepoint connectors (online list and list), again.

       

      Edit: I also tried to connect through Power Query online and I succeeded, so I got the code from the advanced editor. But when I apply to Power BI Desktop, I keep returning this error.