Forum Discussion
Linking PowerBi to A SharePoint excel sheet saved within SharePoint
I am trying to link an excel file saved in SharePoint into PowerBi as a data source. When I want to add a data source I click in PowerBI desktop get data. I click SharePoint Folder. It has only two options for adding data through SharePoint. One is a SharePoint List and the other is a SharePoint Folder. I click SharePoint Folder and it then asks me for a URL. I copy and paste the URL from the direct Excel sheet link that is in SharePoint but it does not work. So I try cutting it down a bit. Eventually of cutting it down a lot it seems to work but it does not show me any of the data from that Excel sheet. It shows data that is not even related to anything I need. How do I narrow down the information in the URL but still have it show up as that specific data source?
3 Replies
I had the same issue last week, I found that clicking Get Data and choosing Web as the source worked. Copied the link to the document into the URL box, and hit next. It asked me to sign in, I chose Organisation Account and logged in as usual, and it changed to an Excel type source but with a web location. Not sure why it was so round-about.
Hmm. I remembered that I ended up rewriting the URL so it didn't have the ridiculously long one, just the standard https://company.sharepoint.com/Shared%20Documents/path/to/document.xlsx
Maybe that will help?