Power View is the new whiz bang reporting tool by Microsoft that is part of the next generation of easy to use yet powerful data visualisation tools. For a start if you don’t have at least Excel 2010 (with at least the Power Pivot add-in 2012 RTM installed), Sharepoint Server 2010, SQL Server 2012 Business Intelligence, Developer or Enterprise editions, then forget it. But if you do have all of the above, and you havn’t using Power View previously, you are in for a visual treat.
To embark on a quick guide to launching Power View read on…
Unlike Report Builder, launching a Power View report begins with creating one of the data sources that Power View supports. These data sources include a Power Pivot database, a BISM Connection file or a Shared (Tabular) Data Source. To create a Power View report from Power Pivot, click the Create Power View report icon from the upper right hand corner of the Power Pivot xlsx file. Yes you must have Excel 2010 to run the free to install Power Pivot 2012 RTM add-in. To create a Power View report within Sharepoint, click the down arrow next to the Shared Data Source or BISM Connection File and select Create Power View Report. The Power View design environment then opens and you will be able to start creating exciting visuals using this exciting new reporting tool.
If you are unable to launch Power View or cannot create a BISM Connection file from within your document library, you will need to make some adjustments to the features for your site. For a start we assume you have correctly integrated Reporting Services and Power Pivot to your Sharepoint Server 2010 environment (only basic Reporting Services integration under Sharepoint Foundation 2010). Now go to the site that contains the document library you will be storing your Power View reports, select Site Actions, Site Settings, Site Collection Features then ensure the Power View and Power Pivot Integration Features are Active. The BISM Content Type must be specifically enabled for your document library which you can access under Library Settings, Advanced Settings, and Add from Existing Content Types.
Further material available here.