Power BI

Completed

SharePoint Online Document Library

Vote (285)

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)

Comments (41)

c5c7ff50 a060-445f-ac93-32dfd35750dc on 05 Jul 2020 22:02:59

RE: SharePoint Online Document Library

do we have a planned date for this yet?

e91d03af 86e9-487e-8393-c6f4a06701a2 on 05 Jul 2020 22:02:39

RE: SharePoint Online Document Library

Getting data from Excel files on SPO should be an out of the box feature.

9d47cfab ba7b-e811-a965-000d3a1bec70 on 05 Jul 2020 22:02:24

RE: SharePoint Online Document Library

Absolutely - if you do it via OneDrive there is no way a traditionnal SharePoint library should be overlooked. It would be great!!

0625f7e8 8ce6-4dce-b8b1-6c9c86713efb on 05 Jul 2020 22:01:54

RE: SharePoint Online Document Library

Allow Power BI to have a large document library with metadata column as a refreshable data source.

1e24f291 5acb-48b2-8662-0bdc340d951f on 05 Jul 2020 22:01:53

RE: SharePoint Online Document Library

Definitely want this. Let us manage the refresh of our excel workbooks ourselves, and then have PowerBI dashboards refresh based on that!

e80911ab ae54-4fe3-86c0-bde9a65733e1 on 05 Jul 2020 22:01:52

RE: SharePoint Online Document Library

Yes, this is exactly what we need as well! Please make it happen Microsoft! I agree with Yiannis, this should be standard

94e21a1d 702e-43a3-9f13-baf63c102106 on 05 Jul 2020 22:01:45

RE: SharePoint Online Document Library

Add SharePoint online as a data source

615c6aec 6f8b-4576-a316-dd9e293092b1 on 05 Jul 2020 22:00:56

RE: SharePoint Online Document Library

We need to see the implementation of the new powerbi sites under E3 and E4 accounts.

45868819 c30c-4049-928f-26505331cc33 on 05 Jul 2020 22:00:10

RE: SharePoint Online Document Library

We would like to collaborate our SPO telemetry reports in Excel files and access SPO files in Power BI directly and create dashboard tiles. Do not want to create extra work in storing files in OD4B.

7d37cdbf c2f7-4abb-9836-e1ca03c4c83f on 05 Jul 2020 21:57:29

RE: SharePoint Online Document Library

However you implement it, the "one stop shop" concept is going to be important. Users won't want to have to go to Power BI for dashboards, SSRS for reports and SPO for Excel OLAP analyses.