Configuring Business Intelligence Site Setting in SharePoint 2013

This is part 2 of the series on creating a Business Intelligence Site on SharePoint 2013. In Part 1, I show you how to quickly create a Business Intelligence Site, please refer back if you have not gone through it yet.

Let proceed to the site configuration.

From the Actions menu click Site Settings.

Scroll down and click Site Collection features. Make sure features below are activated:

• PerformancePoint Services Site Collection Feature.
• Power View Integration Feature.
• PowerPivot Feature Integration for Site Collections.
• Report Server Integration Feature.
• SharePoint Server Enterprise Site Collection Features.

Click Back button on the browser to return to Site Setting page.

Click Manage Site Features. Make sure features below are activated:

• PerformancePoint Service Site Feature
• ReportServer File Sync
• SharePoint Server Enterprise Site Features

Now the site has all required features enabled for BI. We will proceed with adding required App to the site in the next post.

Creating a Business Intelligence Site in SharePoint 2013

This is the first part of the series of tips on Creating a Business Intelligence Site in SharePoint 2013 where I will show how we can quickly create a BI site using SharePoint 2013 Central Administration.

Launch Central Administration and click on the Application Management from the navigation tree of the left side of the screen.

Under the Site Collections section click Create site collections.

Enter Title, Description and URL info.

In the Template Selection, go to Enterprise tab and select Business Intelligence Center. Scroll to the bottom and click OK.

Click on the link to open the newly created Business Intelligence Center.

Now you have a basic Business Intelligence Site.

I will talk about Site Setting configuration in the next post.

How to Change Power View Report Data Source

I am recently building a BI environment on SQL Server 2012 and SharePoint 2013 and also developing reports using Power View. One of the most common task people have is migrating Power View reports from one sites collection to other sties or from one server to other server for whatever reason. However you might get error on connecting to entity data source after migration if you are migrating the PowerPivot data source as well. Below is the steps on how you can change the report data source.

Go to the document library where you stored the Power View report. In the library ribbon, set current view to "All Documents" as shown below.

Select the report, click the down arrow and select "Manage Data Sources".

Click on "EntityDataSource",

Change the Data Source Connection string and click OK.

It should now go back to SharePoint page and the report will render correctly.