Power View Overview

Power View Overview

This is the TechNet Wiki page for Power View, a feature of Microsoft SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition. Power View is an interactive data exploration, visualization, and presentation experience.

Important: Please visit Power View documentation on office.microsoft.com for the most up-to-date content. Power View is now a feature of Microsoft Excel 2013, and as part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from data models based on PowerPivot workbooks or tabular models deployed to SQL Server 2012 Analysis Services (SSAS) instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010.

See What’s new in Power View in Excel 2013 and in SharePoint Server.

Crescent report with visualizations

Useful links for Power View, SQL Server Reporting Services, and SQL Server 2012

Training and Samples

Tutorial: Create a Sample Report in Power View updated for SQL Server 2012 RTM
Tutorial: Optimize a Sample PowerPivot Model for Power View Reports updated for SQL Server 2012 RTM

Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012 RTM
Power View samples you can try yourself: Oil and gas, schools, toy sales, car and auto, and yes, picnic

Community Resources

 Microsoft MVP Jen Stirrup Talks Trellis Charts And Power View!
Using Database Images in Tabular BI Semantic Models with Power View, Dan English 
 Visualizing Data with Microsoft Crescent book just out by Brian Larson, Mark Davis, Dan English, and Paul Purington
Books Online News
Deployment Checklist: Reporting Services, Project Crescent, and PowerPivot for SharePoint


Leave a Comment
  • Please add 3 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
  • Richard Mueller edited Revision 69. Comment: Removed (en-US) from title

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
  • Ed Price - MSFT edited Revision 21. Comment: Formatting

  • maggiesMSFT edited Revision 22. Comment: Featuring the article on the Home Page of TechNet Wiki.

  • Congrats on this article being featured on the front page of TechNet Wiki!

  • Good article for someone starting up with Project Crescent.

  • Good one

  • Ed Price - MSFT edited Revision 29. Comment: Changed the See Also section at the bottom, which is a section title for other Wiki articles. We use "Community Resources" for external links.

  • Bill Ramos edited Revision 30. Comment: Update title and opening paragraphs to reflect the new name

  • Maggie,

    I noticed font size differences here, and it should also probably mention that it used to be called "Project Crescent" (since links to Project Crescent still lead here). Do you want to do those changes, or shall I? Thanks!

  • Ed Price - MSFT edited Revision 45. Comment: "TechNet Wiki" uppercase and equalized font size.

  • Thanks for sharing!

  • Thanks very much for the details. I am able to make crescent dashboards.  Can i have pirchart and KPI's in crescent? Adding that it could be a great presentation solution.



  • Hi, Ashish -- Thanks for your feedback! No pie charts or KPIs yet... cheers -- maggie

  • It's really cool!

  • Thanks for sharing!

  • Horizon_Net edited Revision 65. Comment: added language tags

Page 1 of 2 (18 items) 12