Forum Discussion

andywil456's avatar
andywil456
Advocate II
10 years ago
Solved

Import Data from an Excel sheet in SharePoint

I'm trying to get data from an Excel spreadsheet stored on SharePoint.   I have tried doing this by the URL path but it cannot find at file level. The only way that seems to work, is  to download th...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi andywil456,

    You can import data from Excel stored in SharePoint to Power BI Desktop by using “Get Data>Web” option as follows.




    Based on my test, it works as expected when I enter the URL of Excel file via the option, data is imported successfully to Power BI Desktop.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This entire post thread needs to be consolidated and documented in the official Power BI documentation site.

 

It is SO HARD to work this out from within Power BI Desktop and I only do it a few times a year and I STILL forget the process at times!

 

 

NirH_at_BITeam's avatar
NirH_at_BITeam
Frequent Visitor
7 years ago

Agree!

This process needs to be well documented. I often need to share an Excel file wich serves as my database to an organizational sharepoint so others can use it and update the file. Everytime I do it I encounter so many challanges that are not related to org restrictions but mainly to the way Power BI works with sharepoint...