Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

v-mifole

SharePoint Online Document Library

Submitted by on ‎12-17-2014 04:22 PM
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.
Status: Completed
See more ideas labeled with:
42 Comments (42 New)
Comments
lenzy_petty1
New Member
‎07-05-2020 03:08 PM
Please do it!!!!! I have files updated on Sharepoint quite frequently
david39
New Member
‎07-05-2020 03:09 PM
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.
ljeannette
New Member
‎07-05-2020 03:09 PM
Since this is a feature of O365 it is kind of strange that you can't connect to documents stored there.
idoluv2gab
New Member
‎07-05-2020 03:10 PM
What is the status on this "Must Have" functionality?
vigadani
New Member
‎07-05-2020 03:10 PM
I'm still amazed that this is still not available...
rusd_robc
Advocate I
Advocate I
‎07-05-2020 03:12 PM
One Drive storage is not manageable for a team, or for automation. This is a much needed feature. Wow this is a year old?
simon_bloxham
New Member
‎07-05-2020 03:13 PM
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?
davisn
New Member
‎07-05-2020 03:13 PM
somebody should retweet this out back to Microsoft. I don't have twitter.
marc007
New Member
‎07-05-2020 03:16 PM
Unfortunately, there is a bug in Power BI Desktop when pointing to a SharePoint document library to pick up an excel file!
adunn3
New Member
‎07-05-2020 03:19 PM
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.