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.

  2. Melissa Coates – Charlotte, NC – Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As a BI Architect with BlueGranite, she specializes in delivering BI and Data Warehousing solutions using Corporate and Self-Service BI tools.
    Melissa Coates says:

    I ran into the exact same thing – reinstalling the newest version of PowerPivot (as George pointed out in the previous comment) solved it for me as well.

  3. Aashish Koirala – I build software for a living. .NET happens to be my primary platform of choice. I also like to do it just for fun and to put stuff out there. I like to think about architecture, building better software and making the process of building software better. And I also like to write about all of this.
    Aashish Koirala says:

    I’m certainly glad I read this – I was about to do the exact same thing. Is this documented in MSDN or TechNet anywhere?

    1. Chris Webb – My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel.
      Chris Webb says:

      No, it’s not documented anywhere as far as I know.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.