locked
Pivot Pivot - Power Pivot Report on Sharepint Perfomance understanding RRS feed

  • Question

  • Hi All,


    I am working on SharePoint Power Pivot and Power View Report, Can anyone help me to understand, how reports performance can vary if I store multiple reports ( considerably huge in size) in one Power Pivot Gallery of site . OR , what if I can create multiple sites and store report against it. So, I mean, just want to distribute  reports in multiple sites as per report design/understanding. Will it help me in terms of faster report access.


    Thanks and Warm Regards,

    Sandip

    Monday, April 7, 2014 9:22 AM

Answers

  • So the individual reports will run the same speed regardless of how many reports are in a given library.

    But what will be faster will be the loading of the Power Pivot Gallery page. We've found that the sliverlight Gallery view is too slow if you get a lot of reports in the one gallery (to the point where we are now using our own custom view). 

    Splitting up the reports among multiple libraries or switching the default view from Gallery to list would help.


    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by Elvis Long Tuesday, April 15, 2014 2:56 AM
    Thursday, April 10, 2014 6:35 AM
  • Hi Sandip,

    Here is a good article regarding Power View report performance troubleshooting for your reference, please see:
    Tracking down Power View Performance Problems: http://blogs.msdn.com/b/psssql/archive/2013/07/29/tracking-down-power-view-performance-problems.aspx

    Please also take a look at the KB article below:
    FIX:  Slow performance when you render a Power View report that uses a SQL Server 2012 SP1 PowerPivot workbook as its data source: http://support.microsoft.com/kb/2846345/en-us

    Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Tuesday, April 15, 2014 2:56 AM
    Friday, April 11, 2014 4:32 AM

All replies

  • So the individual reports will run the same speed regardless of how many reports are in a given library.

    But what will be faster will be the loading of the Power Pivot Gallery page. We've found that the sliverlight Gallery view is too slow if you get a lot of reports in the one gallery (to the point where we are now using our own custom view). 

    Splitting up the reports among multiple libraries or switching the default view from Gallery to list would help.


    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by Elvis Long Tuesday, April 15, 2014 2:56 AM
    Thursday, April 10, 2014 6:35 AM
  • Hi Sandip,

    Here is a good article regarding Power View report performance troubleshooting for your reference, please see:
    Tracking down Power View Performance Problems: http://blogs.msdn.com/b/psssql/archive/2013/07/29/tracking-down-power-view-performance-problems.aspx

    Please also take a look at the KB article below:
    FIX:  Slow performance when you render a Power View report that uses a SQL Server 2012 SP1 PowerPivot workbook as its data source: http://support.microsoft.com/kb/2846345/en-us

    Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Elvis Long Tuesday, April 15, 2014 2:56 AM
    Friday, April 11, 2014 4:32 AM