Michael Foley on 18 Dec 2014 00:22:52
We have many Excel files on SharePoint Online Document Libraries - well structured and maintained and refreshed. It would be great to be able to point to those directly. The OneDrive for Business is similar, but it would mean we have to duplicate the files from our existing SPO team site. So it would be great to access Excel files located on SPO team site document libraries.
- Comments (41)
RE: SharePoint Online Document Library
This says completed, but how does it work? I can't seem to use the contents of an excel file stored on SharePoint as a connected data source. I can do this in the Power BI online tool, using the get data feature, but not on Power BI Desktop? Can someone walk me through the steps? I am a bit new at this. Thanks!
RE: SharePoint Online Document Library
Maybe I'm misunderstanding the problem, but we do this all the time.
In the query editor, for the source point to the path of your Excel file in SPO:
Source = Excel.Workbook(Web.Contents("https://yourcompany.sharepoint.com/dashboards/Shared%20Documents/powerBI%20datafiles/powerBI%20datafile.xlsx"), null, true),
That works every time.
To get the document URL, get a link to the containing folder and then append the file name to that (spaces need to be replaced by “%20”).
Let me know if that solves your problem.
RE: SharePoint Online Document Library
Unfortunately, there is a bug in Power BI Desktop when pointing to a SharePoint document library to pick up an excel file!
RE: SharePoint Online Document Library
I can't see any of our SP folders in this view, do they have to be configured in a specific way for Power Bi to see them?
RE: SharePoint Online Document Library
somebody should retweet this out back to Microsoft. I don't have twitter.
RE: SharePoint Online Document Library
One Drive storage is not manageable for a team, or for automation. This is a much needed feature. Wow this is a year old?
RE: SharePoint Online Document Library
What is the status on this "Must Have" functionality?
RE: SharePoint Online Document Library
I'm still amazed that this is still not available...
RE: SharePoint Online Document Library
Since this is a feature of O365 it is kind of strange that you can't connect to documents stored there.
RE: SharePoint Online Document Library
You can access Salesforce, Twilio and even MailChimp, but if you want to access Microsoft Team Sites data you have to vote for it? That makes no sense.