locked
Local refresh of upgraded Powerpivot report are really slow RRS feed

  • Question

  • Hi everybody,

    My customer has just upgraded from Office 2010 to Office 2013 Pro.
    They also upgraded their powerpivot reports.
    When they refresh these reports from their local computer the data refresh are far slower than in 2010.
    When they create brand new reports from Office 2013 Pro, the refresh is faster.
    Their 2010 reports are really complex and we want to avoid to rewrite them.
    Have you heard about such problems?
    How can we fix this?

    Thanks for your help.

    Pete 
    Friday, April 3, 2015 4:12 PM

Answers

All replies

  • Hi Pete,

    According to your description, you are experiencing the performance issue when refresh data in PowerPivot report after upgraded from Office 2010 to Office 2013 Pro, right?

    We cannot reproduce this issue, and it's hard to say root reason that caused the performance issue. There are many facts that impact data refresh. Here are some articles about the troubleshooting tips and techniques for working through data refresh issues with PowerPivot.
    https://msdn.microsoft.com/en-us/library/gg399164%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396
    http://social.technet.microsoft.com/wiki/contents/articles/3870.troubleshoot-powerpivot-data-refresh.aspx

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Charlie Liao Monday, April 27, 2015 3:17 AM
    Wednesday, April 8, 2015 3:24 AM
  • Hi Pete,

    In addition to studying the links Charlie has kindly supplied.

    Can you give me an indication of the number of rows in your largest tables, number of records, etc. The 64 bit version of Excel 2010 / 2013 has much better memory management than the 32 bit version within Power Pivot. I have also found the following link useful; - Create a memory-efficient Data Model using Excel 2013 and the Power Pivot add-in. However there may be an issue getting some of your existing macros working with the 64 bit version. I appreciate that ideally you should not have to rework your design after upgrading. However a small number of design changes may be a pragmatic way forward.

    Kind Regards,

    Kieran.


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/


    Thursday, April 9, 2015 7:28 AM
  • Where you using PowerQuery to do the data pulls?  And maybe when you upgraded you got the newest version?

    (With the latest PowerQuery update, I found a few Queries needed to be rebuilt because of slowness.   Have been on Office2013 64x for a while so that was the only change)

    Thursday, April 9, 2015 10:00 AM