Which of MS EXCEL versions support Power View feature?

Whether or not you will be able to use Power View, quite a useful feature to display interactive reports, depends on the Excel architecture.

Excel comes in the most popular and most common x32 bit version. Many add-ins are compatible with this version. At least that is the reason Microsoft offers for not installing x64 bit version of MS Excel. Also, both versions cannot co-exist, it is one or the other. 64bit Office can work on only x64 computers but this is not really serious we will be seeing fewer and fewer x32 bit computer. The way out is for Microsoft to take a bold step to bring these differences to a close.

People who have more complex worksheets require 64-Bit office 2013.

Power Views are only supported on these versions and SKUs:

PowerViewExcelVersion.jpg

What do you need to author a Power View Report?

This is the first question that you ask yourselves.

As Power View report is based on data it finds on a tabular data model, you need SQL Server Analysis Services(SSAS) server, which can host a tabular model. This means that you must have
configured the SQL Server Analysis Server to support tabular model. You create
the tabular model using SSDT, which installs when you install SQL Server 2012.

However with SQL Server 2014 which went RTM recently you can create Power View Reports as well as DAX queries using the Multi- dimensional models.

Installing SSAS to support tabular model was covered in Chapter 1, Overview and
Installation – SQL Server Reporting Services 2012 of my book Learning SQL Server Reporting Services 2012.

Also, as the PowerView is launched from SharePoint Server 2010, you want
the SQL Server Reporting Services 2012 configured to operate in integrated mode
with SharePoint Services. Installing Reporting Services 2012 in SharePoint Integrated mode was
described in Chapter 1 , Overview and Installation – SQL Server Reporting Services 2012 of my book..
The Power View reports in the above chapter are based on these premises. Power Views
are only possible for enterprise-grade servers for both SharePoint Server 2010 and
SQL Server 2012.
The environment for developing Power View described in this book is based on
the following:
•  Possibility of installingSharePoint 2010 Server on Windows 7 (x64) computer
•  Installing SQL Server 2012 Reporting Services in SharePoint Integrated mode
•  Configuring SQL Server 2012 Analysis Services to support tabular
data model
•  Availability of a Silverlight-enabled browser