Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Thank you for that information! I gave it a shot but it is still not working for me. I may have too big of a link for the excel file.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |