Forum Discussion

rhyslowe's avatar
rhyslowe
New Member
7 years ago
Solved

Cannot link a Sharepoint Excel file to Desktop PowerBI

Hi all,   I'm very new to PowerBI, I'm struggling to pull data from an excel data we have shared on an ogrniazational sharepoint site.   I think the issue is to do with the link that I'm using, I...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    rhyslowe,

    The root URL of your sharepoint site is https://xxxxx.sharepoint.com/sites/<sitename>, right? If so, please use the URL https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx to connect to your file.

    Please note that to connect to Excel that is located under Documents of SharePoint online site, use the URL below.
    https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx

    To connect to Excel that is located under a folder in SharePoint online Documents, use the URL below.
    https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

    Regards,
    Lydia

    Regards,
    Lydia

rhyslowe's avatar
rhyslowe
New Member
7 years ago

Hi Lydia,

 

Thanks for your reply.

 

I'm still struggling to get it to work.

 

I don't suppose I could politely ask if you could Teamviewer onto me please? :)

 

I'm sure I'm just doing something stupid.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

rhyslowe,

We are not allowed to Teamviewer onto customer. You can share screenshots here for us to troubleshoot. Please do mask sensitive information when you upload screenshots.

Regards,
Lydia

  • rhyslowe's avatar
    rhyslowe
    New Member
    7 years ago

    Hi Lydia,

     

    Okay that's no problem, I understand.

     

    I'll just start simple, where would I get the link for this document in order to link it to PowerBI?

     

    I did try ttps://xxxxx.sharepoint.com/Shared%20Documents/Forms/ but had no luck.

     

    Thanks

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      rhyslowe,

      The root URL of your sharepoint site is https://xxxxx.sharepoint.com/sites/<sitename>, right? If so, please use the URL https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx to connect to your file.

      Please note that to connect to Excel that is located under Documents of SharePoint online site, use the URL below.
      https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx

      To connect to Excel that is located under a folder in SharePoint online Documents, use the URL below.
      https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

      Regards,
      Lydia

      Regards,
      Lydia

      • pdacheva's avatar
        pdacheva
        Icon for Advocate II rankAdvocate II
        5 years ago

        Hi all,

         

        Trying to set a connection with the Web connector to a Sharepoint file (not using the Sharepoint folder one due to some O365 issues we find and trying this workaround).

        I use this URL:

         

        https://myorganization.sharepoint.com/teams/nameofmysie/Shared%20Documents/nameofmyfile.xlsx, but no luck - I get an error message that I don't have access to it, which is not true.

        Note that the Sharepoint is not "sites", it's "teams", but this is the Sharepoints URL we have.

         

        Any suggestions on how to successfully generate a WEB link to this Sharepoint?

         

        Thanks!