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)

Daniel Wu on 05 Jul 2020 22:02:59

RE: SharePoint Online Document Library

do we have a planned date for this yet?

Kenley Lamaute 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.

Marc-André Lépine 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!!

BG 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.

Steve Herbert 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!

Shaun 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

Power BI User on 05 Jul 2020 22:01:45

RE: SharePoint Online Document Library

Add SharePoint online as a data source

aligizakis 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.

Power BI User 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.

Power BI User 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.