SharePoint24x7 It's all about SharePoint.


Article – Fixing PowerPivot Management Dashboard Errors

Posted by Joy

We installed SQL Server PowerPivot for SharePoint and we also executed PowerPivot for SharePoint 2013 Configuration tool and configured PowerPivot for SharePoint.

Now we need to make sure that PowerPivot Service Application instance is configured correctly for us to move forward. Unlike any other service application settings/ configuration pages, PowerPivot Service Application instance settings page is considered as the Dashboard for PowerPivot Service Application instance.

Let’s go and explore PowerPivot Service Application instance and it’s configuration.

  • Open SharePoint 2013 Central Administration web site. Click Manage service applications from Application Management section.
  • Click PowerPivot Service Application instance name to navigate to PowerPivot Management Dashboard.PowerPivot Service Application instance
  • Most of the time, you will end up getting following screen. You will see Excel Services error in the Infrastructure – Server health web part and another error in Workbook Activity – Chart web part. The reason for this error is, App Pool Service Account doesn’t have access to Central Administration content database.PowerPivot Management Dashboard
  • Open SQL Server Management Studio and connect to Database Engine.
  • Expand Databases folder and locate the SharePoint Central Administration content database. Expand the Security folder and then expand the Users folder.Granting membership in SQL Server
  • Select the App Pool Service Account, right click the user account and select Properties. Select Membership page from the Select a page list. Select SPDataAccess database role membership.Granting membership in SQL Server
  • Click OK and close SQL Server Management Studio.

Now you can go and verify PowerPivot Management Dashboard to see that both Red X are gone.


Article – Creating a BI Center and Testing Excel Services

Posted by Joy

Business Intelligence (BI) is one of the most compelling features in SharePoint. All the BI features of SharePoint come with the Enterprise edition of SharePoint. Following are some of the BI components come with SharePoint:

  • Excel Services
  • Visio Services
  • Access Services
  • Power View
  • PowerPivot
  • PerformancePoint Dashboard

In order to leverage all of these BI features in SharePoint, you need to create and configure a BI Center in SharePoint. In this article I will guide you through the process of creating a BI Center in SharePoint and testing Excel Services as Excel Services being a very important/ core feature for rest of the BI features in SharePoint.

Creating a BI Center

  • Navigate to SharePoint 2013 Central Administration web site
  • Select Create site collections link from Application Management sectionApplication Management section
  • From the Create Site Collection page, make sure you select the correct Web Application in which you want to create the BI Center. Provide a Title and an option Description. Provide a URL.Create Site Collection page
  • From the Select a template: section, go to Enterprise tab and select Business Intelligence Center site template. Provide a Primary Site Collection Administrator and click OK.Create Site Collection page
  • It will notify you saying that Site Collection has been successfully created. Open the new site and it will take you to the home page of the new BI Center.BI Center

Testing Excel Services

  • From the BI Center home page, from the Left Navigation (Quick Launch), select Site Contents link.BI Center
  • Select Documents libraryCapture7
  • Click the name of the Excel Services Sample Workbook to test the Excel Services.Capture8
  • You will see the following output if you have configured Excel Services correctly.Capture9

Now you are all set to explore rest of the BI features of SharePoint 2013. Smile