Chapter 24. Configuring a Gallery for Reporting Services, Power View, and Excel Services

Before we get into the details of creating some SQL Server Reporting Services reports, Power View reports, and Excel Services, we have a few quick steps to get our SharePoint Site ready.

Note

In this chapter, we assume some previous experience with SharePoint and that you are familiar with the concept of SharePoint features.

SharePoint features are bundles of functionality that can be activated by users with appropriate rights enabling a set of capabilities in the product.

Enabling Required Features

In this case, let’s start by ensuring that a few Site Collection scoped features are enabled. Without these features enabled, SharePoint will not have the components to support the business intelligence scenarios we’ll be walking through during this solution. To enable them, navigate from the Site Actions menu to Site Settings to Site Collection features, as shown in Figure 24-1. Enable the following features:

  • Power View Integration Feature

  • Power View Integration for Site Collections

  • Report Server Integration Feature

Managing Site Collection features

Figure 24-1. Managing Site Collection features

If these features were already enabled, that’s no problem. Different SharePoint site definitions will start with different features enabled; we just want to confirm that they are enabled in order to complete the following tasks.

Creating the PowerPivot ...

Get Developing Business Intelligence Apps for SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.