Newly published this week is the final version of the PowerPivot for SharePoint – Single Server Installation Guide. I’ve updated the “Server Installation” pointers at the top of my blog to indicate the new pointers. If interested, visit here: http://powerpivotgeek.com/server-installation/single-server-install-rtm/
Because PowerPivot for Excel and PowerPivot for SharePoint involves so many components from SQL Server 2008 R2 Analysis Services, Office 2010, and SharePoint 2010, this poster provides an end-to-end view of the PowerPivot Security Architecture in one view. This view includes nearly all of the logical security surface areas and illustrates how these systems interact.
Recently there have been several asks on the forums about getting more information for installing PowerPivot on a standalone server. Well . . . we have a video produced that addresses how to do this. Besides the installation itself, I also discuss how you go about adding the domain controller role to the server and [...]
Recently a question has come up on one of the forums about the number of rows that PowerPivot can load. Clearly PowerPivot can hold a lot – just look at our demos. Millions and millions . . ah . . but how many millions?
The key geek ‘magic’ is the Vertipaq engine. The in-memory Vertipaq engine [...]
From time to time I get questions from folks asking me “What is the best debugging tool for PowerPivot?” – The Answer is that there is clear cut favorite and it is EXTREMELY useful, but I didn’t know that it was released to the public. Well . . . after some investigation, it looks like [...]
Microsoft does not recommend or support the use of Office applications in a server-side environment (see http://support.microsoft.com/kb/257757 ). In the case of PowerPivot, the data refresh facility is implemented within an NT Service and, as such, falls under this restriction. In this article we will use the ACE provider to give you more control [...]
Microsoft does not recommend or support the use of Office applications in a server-side environment (see http://support.microsoft.com/kb/257757 ). In the case of PowerPivot, the data refresh facility is implemented within an NT Service and, as such, falls under this restriction. If you are using Office data within a PowerPivot workbook (e.g. importing the data [...]
A series of new videos have just been posted that talk about the PowerPivot for SharePoint architecture. This 4-part series is about how user identity is established and flows in different PowerPivot environments.
Part 1: SharePoint User Identity Fundamentals for PowerPivot Administrators = http://www.youtube.com/user/sqlserver#p/u/8/uku4KuzQDIk Part 2: Security context of PowerPivot Connections in [...]
For those interested, I’ve been able to get some of the PowerPivot demos running again. Here is a quick status:
Contoso Retail Warehouse workbook: RUNNING!
NFL Stats: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
USDA Analysis: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
NBA Stats: [...]
(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)
Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and [...]