Forum Discussion
Import Data from an Excel sheet in SharePoint
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
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
Hi Anonymous,
May I know where exactly did you get the URL from? I have created a web page which contains an excel file and I am using the Web data source just like the way you are dping but I don't know which URL to put and where to get it from.
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"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.
I needed to do one more step.
Remove "Forms/AllItems.aspx"
Then I appended my file name.
It worked for me after doing above steps along with the steps mentioned in your post.
I am having a credentianls issue as well!
Power Bi "(404) not found
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"This actually works really well!
Thank you so much.. 🙂
