PowerView experience will be delivered across several Microsoft products:
- Excel (fat client)
- Excel Services (SharePoint)
- SharePoint – SQL Edition
- Office 365
- PowerPoint
I get a lot of questions as to what features are supported across all these deployment scenarios. Luckily Microsoft shared a slide that I will attempt to reproduce here that explains what features work where and how.
Feature |
Excel |
Excel Services |
SharePoint/SQL |
Office 365 |
All visualizations |
Yes |
Yes |
Yes |
Yes |
Power View Authoring |
Yes |
No |
Yes |
No |
Cross Visualization Interactivity |
Yes |
Yes |
Yes |
Yes |
External Images |
Yes, anonymous |
Yes, anonymous |
Yes |
Yes |
Workbook or model size |
Max Workbook Size |
AS Limits |
AS Limits |
10MB |
Export to PowerPoint |
No |
No |
Yes |
No |
Reorder Power View views |
No |
No |
Yes |
No |
Connecting to multidimensional UDM |
No |
No |
Yes |
No |
Offline Mode |
Yes |
No |
No |
No |
Multiple External Models |
Yes |
Yes |
No |
Yes |
Report Zoom |
No |
Browser Zoom |
Browser Zoom |
Browser Zoom |
Reading and Presentation mode |
No |
No |
Yes |
No |
Windows RT support |
No |
No |
No |
No |
Windows 8 Pro support |
Yes |
Yes |
Yes |
Yes |
There are several interesting points to make here.
- Microsoft thinks of “Export to PowerPoint” as a feature as opposed to thinking of PowerPoint as another environment for Power View like Excel even though the PowerPoint does support the authoring capability as it is outlined here
- There seems to be some fragmentation in several important features such as ability to support multidimensional models and multiple external models
- No Windows RT support is very annoying (given the fact that RT is happily supporting Flash but not Microsoft own Silverlight). I understand (although do not agree with) that Microsoft had to scale down the RT functionality in order to please its hardware partners; however, I do not understand why I do not even have an option to BUY the missing functionality such as Silverlight, Outlook, etc. (or rather the entire Office Professional) for Windows RT. As I mentioned before, I love the Surface from the hardware perspective, however, I believe that I should be able to have an option to upgrade my user experience to the full featured product for additional $$$ if I have to
Very informative post, I like the table – very useful and comprehensive.
I just wrote an article on Microsoft Office alternative that work really well if you are interested in that: http://scientificocean.wordpress.com/2012/11/16/how-to-turn-your-back-on-microsoft-office/