Posts Tagged 'Configuration'

PowerPivot Technical Architecture Diagram Released: Security Architecture

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.

Included in this diagram are:

  • Service Accounts
  • SharePoint Databases
  • Security Hardening
  • Automatic Data Refresh
  • User Identity Flow
  • PowerPivot Permissions Levels

Please click through to continue reading: PowerPivot Technical Architecture Diagram


Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

August 21, 2010 by dennyglee

One of the cool things with PowerPivot is to click on an SharePoint List’s Export as Data Feed (i.e. an ATOM feed) and its data can be imported directly into a PowerPivot for Excel workbook.  To get this thing to work, one of the key things that I remind people regularly is to make sure you install  ADO.NET Data Services Update for .NET Framework 3.5 SP1.

So after doing this multiple times, I proceeded to do my usual atom feed import like I usually do:

Please click through to continue reading Help, my PowerPivot for SharePoint Lists Atom Feed has fallen and it can’t get up!

SharePoint 2010 revised ULSViewer

By powerpivotgeek (, on August 21st, 2010
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 it is available – not only that, it has been for a while. But better late than never . . take a look at it!

Please click through to continue reading SharePoint 2010 revised ULSViewer

PowerPivot Technical Diagram: PowerPivot Security Architecture

Just in case you didn’t already know, we just uploaded the PowerPivot Security Architecture technical diagram on to / MSDN.  To get access to the PDF, XPS, and/or VSD files, please click through to:

 PowerPivot Security Architecture


[Note, this is cross posted from in its entirety]

Don’t forget your Central Admin when creating AAM entries

By powerpivotgeek (, on August 2nd, 2010

(my thanks to Dan English 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 verify that the location is correct”. The file was there; he could be seen it using WebDAV “\\ServerName@CAPort#\PowerPivot Management\<guid for service application>\1033\Workbook Activity.xlsx” or the UI:

Please click through to continue reading Don’t forget your Central Admin when creating AAM entries

If running on Windows Server, make sure you have ‘Desktop Experience’ feature turned on

By powerpivotgeek (, on July 12th, 2010

Oh the joys of SharePoint again. I just responded to an internal posting where someone was raising the issue that “Path not found” errors were being reported when Excel Desktop tried to publish a workbook to SharePoint. Again, this isn’t PowerPivot directly, but it can be reported as a PowerPivot problem if the workbook contains PowerPivot data.

Continue Reading: If running on Windows Server, make sure you have ‘Desktop Experience’ feature turned on 

Client: What happens if I install the wrong ‘bitness’?

By powerpivotgeek (, on June 17th, 2010

Recently ran into this situation: Customer installed the wrong PowerPivot bits on their machine. They were running on a 64-bit OS with Office 2010 x64, but installed PowerPivot for Excel 32-bit. Everything installed OK, but when they clicked on the PowerPivot tab in Excel; then the PowerPivot Window they received the following error:

Click through to continue reading.

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved