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

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
Advocate 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!