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,

It seems that you are connecting to sharepoint online excel in Power BI Desktop. When using web option in Power BI Desktop, please get the web URL of Excel file following the guide in the screenshots below. And please use organizational account method in Power BI Desktop.



If you use SharePoint Folder connector in Power BI Desktop, please enter root URL of your SharePoint site, and use organizationa account method.

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