SQL Server 2012 SP1 CU3 release fixes frequent SP1 issues

We normally don’t comment much on Cumulative Update releases since the best source for this type of information is the blog of the SQL server release services team : http://blogs.msdn.com/b/sqlreleaseservices/ . However, adding to the SP1 issue that was described in previous blog by Guillaume Fourrat we observed two further SSAS related problems that affected several customers….

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….

1 hour timeout for data imports in Powerpivot for Excel

This article describes an issue you may face when your data import in Powerpivot for Excel takes longer than 1 hour. Typically you should not run into this type of issue because Powerpivot for Excel was designed as an interactive tool with moderate amounts of data in mind. 1 hour should give you ample time to import all…

4 GB Limit for Powerpivot text file imports via ACE text data source driver

We have been investigating reports that large text files are not completely imported into Powerpivot. And indeed a thorough investigation showed two unexpected things happening. The text import is cut off at 4 GB Import is shown as successful. This applies to the SQL Server 2008 R2 and the SQL Server 2012 Powerpivot add-in for excel in…

non-admin users not able to use Powerpivot for Excel 2012 on Windows XP

Recently we investigated issues where non-admin users could not open Powerpivot 2012 window in Excel 2010 on Windows XP machines. When trying to open the Powerpivot window they get the following error message: “Embedded Analysis Services Engine: Could not open embedded Powerpivot data” During the investigation it turned out that the “SeIncreaseBasePriorityPrivilege” windows privilege is required for…