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.
42 Comments
- I do not think this should be an option to vote on. SPO is Microsoft's standard way of handling document management in Office 365 - support for this should really be out of the box.
- 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.
- We need to see the implementation of the new powerbi sites under E3 and E4 accounts.
SarahDMicrosoft Employee
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.- Allow Power BI to have a large document library with metadata column as a refreshable data source.
- Add SharePoint online as a data source
- Yes, this is exactly what we need as well! Please make it happen Microsoft! I agree with Yiannis, this should be standard
- Definitely want this. Let us manage the refresh of our excel workbooks ourselves, and then have PowerBI dashboards refresh based on that!
- Absolutely - if you do it via OneDrive there is no way a traditionnal SharePoint library should be overlooked. It would be great!!
- Getting data from Excel files on SPO should be an out of the box feature.
Recent ideas
executeDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...
