PowerPivot for SharePoint – Server Configuration Check


Every once in awhile, you will get an error where you cannot Slice to the Data Model. 

"PivotTable Operation Failed
An error occurred while working on the
Data Model in the workbook.  Please try again."

If this is the case, you will want to make sure PowerPivot is Configured correctly.  To do this, follow the below instructions.

Turn on ULS logging:

 

Tick Excel Services Application > Least critical event to report to the trace log > Medium

On the machine running Excel Services, connect to the ULS log via ULS Viewer > Open From > ULS

 

Filter on Message > Contains > check server configuration

 

Then Stop and Start > Excel Calculation Services. After 30 seconds (or so) you will see an entry:

 

Once you see that, you know the Check Server Configuration took place.

Click on that event and then clear the filter via Edit > Clear Filters

 

You can then see all 4 checks:

 

I will go through all the steps below:

1. Check Administrator Access (AS2012SP1\POWERPIVOT): Pass.

If this fails, it will look similar to:

"w3wp.exe (SP:0x4968)        0x2BE0        Excel Services Application        Data Model        27        Monitorable        –> Check Administrator Access (SQL\POWERPIVOT): Fail."

If this fails, you will need to make sure the account running the PowerPivot Application Pool has access to the Analysis Services machine running PowerPivot. 

Below is where the PowerPivot Application Pool account needs to be present.

2. Check Server Version (sql\POWERPIVOT): Pass (11.0.3393.0 >= 11.0.2800.0).

I don't have an example of this error, cause no one has ever been on a build lower than SQL 2012 SP1.  If this fails, you need to make sure the Analysis Services machine running PowerPivot is at least on SQL 2012 SP1.

3. Check Deployment Mode (sql\POWERPIVOT): Pass.

If this fails, it will look similar to:

"w3wp.exe (SP:0x4968)        0x2BE0        Excel Services Application        Data Model        27        Monitorable        –> Check Deployment Mode (SQL\POWERPIVOT): Fail (Expected: SharePoint, Actual: Multidimensional)."

This means that you did not install Analysis Services in SharePoint Mode.  The above error shows Multidimensional Mode

Below is the correct configuration:

4. Check Server Configuration (AS2012SP1\POWERPIVOT): Pass.

If this fails, it will look similar to:

"w3wp.exe (SP:0x4968)        0x2BE0        Excel Services Application        Data Model        27        Monitorable        Check Server Configuration (SQL\POWERPIVOT): Fail (Uninitialized, ConfigurationError, InsufficientPermission, WrongDeploymentMode)."

This essentially is a summary of the above 3 steps; as you can see the Permission to the Analysis Services machine running PowerPivot were insufficient (account running PowerPivot Application Pool needs to be an Administrator to the /PowerPivot Instance) and the Deployment Mode was not SharePoint Mode.

Additional Resource:
PowerPivot for SharePoint 2013 Installation
http://msdn.microsoft.com/en-us/library/jj219067.aspx
 
Determine the Server Mode of an Analysis Services Instance
http://technet.microsoft.com/en-us/library/gg471594.aspx

Hopefully this helps. 

Comments (1)

  1. Anonymous says:

    Una vez más, os dejo un nuevo recopilatorio de recursos interesantes sobre SharePoint 2013 y sobre todo

Skip to main content