January 20, 2015 at 5:21 am
Powerview is running extremely slow when filtering reports in SharePoint 2013.
The Powerview reports that reside in SharePoint 2013 are connected directly to a tabular cube on Analysis services. When querying the same cube with an identical pivot report in Excel, the performance is much better. Powerview is taking minutes to update reports that take a few seconds to update in Excel.
January 20, 2015 at 7:11 am
This is a fairly good article on determining the source of powerview performance problems: http://blogs.msdn.com/b/psssql/archive/2013/07/29/tracking-down-power-view-performance-problems.aspx
This is a whitepaper on SSAS Tabular performance tuning: http://msdn.microsoft.com/en-us/library/dn393915.aspx
With how your cube is responding faster in excel I suspect your problem may be either a rendering one or an architecture (e.g. network io) one.
Good luck.
January 29, 2015 at 7:22 am
For the Power View report performance on SharePoint site, please refer to the link below which talks about how to track down Power View performance problems.
http://blogs.msdn.com/b/psssql/archive/2013/07/29/tracking-down-power-view-performance-problems.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply