Forum Discussion
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...
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
I wrote this a couple of years ago, but I assume it is still relevant and works with Power BI
http://exceleratorbi.com.au/consolidate-multiple-excel-files-in-sharepoint-using-powerquery/
I thought there was also a new SharePoint connector too.
This was exactly what I was looking for! Thank you!
