Powershell for PowerPivot Service Application …

Powershell for PowerPivot seems to be a bit of a mish-mash really.  There appears to be no way to provision a PowerPivot Service Application using Powershell which doesn’t use the Default Application Pool, and as far as I can see there appears to be no way to change the name of the Service Application database except through the Web UI (somebody please tell me otherwise …?).

Here’s how to change the PowerPivot Service Application Pool to one of your choosing (this script assumes you already have an Application Pool available called “My PowerPivot Service Application Pool” and that your database server is called “MySQLServer”:

New-PowerPivotServiceApplication -ServiceApplicationName "My PowerPivot Service Application" -DatabaseServerName "MySQLServer" -DatabaseName DefaultPowerPivotServiceApplicationDB -AddToDefaultProxyGroup
$sa = Get-PowerPivotServiceApplication | where {$_.DisplayName -eq "My PowerPivot Service Application"}
$applicationPool = Get-SPServiceApplicationPool  | where {$_.Name = "My PowerPivot Service Application Pool" };
$sa.ApplicationPool = $applicationPool;

Easiest way to change the database name it appears is to just do it through the UI.


Dave Mc


About davemcmahon81
Software Developer & Architect, User Group Leader, Speaker, Writer, Blogger, Occasional Guitarist, Man-made Global Warming Sceptic, Climate Change Believer, General Optimist but most of all proud Husband and Dad ...

3 Responses to Powershell for PowerPivot Service Application …

  1. I ran into an error and had to use PowerShell to create the PowerPivot service application. I set the database name in those scripts.

    I wrote a post covering how I did it here: http://kellydjones.com/archive/2011/09/18/146931.aspx

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: