Installing SSAS 2008R2 SP1 breaks PowerPivot

Here’s something I found out a few weeks ago, just before I went on holiday: installing SP1 for SSAS 2008R2 breaks a PowerPivot installation on the same machine. After I’d installed SP1 on my laptop I found I got an “Unable to open file” error message in PowerPivot whenever I tried to import data, at which point PowerPivot crashed. For me the fix was easy – reinstall PowerPivot and it worked again – but I’m glad I found this out before I needed to use PowerPivot in front of a customer.

8 thoughts on “Installing SSAS 2008R2 SP1 breaks PowerPivot

  1. I’ve just found out that reinstall the old version of PowerPivot doesn’t solve the problem. I have to download the latest version of PowerPivot (version 10.50.2500.0, matched to SP1 build number) and reinstall with it.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s