Report Portal

1 hour timeout for data refreshes in Powerpivot for Sharepoint

In the previous blog post I explained that we have a 1 hour timeout in Powerpivot for Excel due to the inherited default SSAS instance properties. Now you might argue that this timeout should not pose a problem in the Powerpivot for Sharepoint environment. After all we are using a standalone SSAS instance in Sharepoint mode. We can thus modify the Instance properties to our liking via the Management Studio properties GUI or SSAS instance configuration file "msmdsrv.ini".

Unfortunately this won't help you. Even if you set your timeout properties to values much higher than the expected data refresh execution time.


Tags: excel, sharepoint, tabular


2007-2015 VidasSoft Systems Inc.