Power View – Self-service Reporting | Reporting with Microsoft SQL Server 2012

Power View within SharePoint

This section describes using Power View within SharePoint. It can be used with the enterprise editions of SharePoint 2010 or SharePoint 2013.

Setup

Although Power View is very easy to use, setting up the required infrastructure when using it with SharePoint can be a bit tricky. Power View is automatically installed when you run the SQL Server 2012 setup and choose Reporting Services Add-in for SharePoint Products on the Feature Selection page. This is a newer version of the add-in, which includes Power View, compared to the version that is installed with SharePoint 2010 that does not include Power View. The following are the software requirements for Power View:

SQL Server 2012 database engine (Business Intelligence Edition or Enterprise Edition).
SQL Server 2012 Reporting Services (in SharePoint Integrated mode).
SQL Server 2012 PowerPivot for SharePoint.
SQL Server 2012 Analysis Services (SSAS) in tabular mode if using a tabular model connection.
SQL Server 2012 Analysis...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Reporting with Microsoft SQL Server 2012

Reporting with Microsoft SQL Server 2012

Overview of this book

Power View within SharePoint

Setup

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access