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/