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

luvallar's avatar
luvallar
Advocate I
9 years ago

Go on your sharepoint
Open the excel file with excel (desktop, not online)
It'll show a pop up with the path (but you won't be able to copy and paste)
So, once Excel is opened:
Click on File
INFO
(bottom right corner) right click on OpenFileLocation
Copy link
then paste it in powerbi AND

add "/nameOftheFile.xlsx"

 

 

 

 

dparkinson's avatar
dparkinson
Advocate I
8 years ago

This worked, thanks.  But now I'm trying to publish to web, I'm getting a failure of credentials.  Any ideas how to get that working?  Many thanks, D.