With all that is going on these days, I have not been doing a good job of keeping this aggregator site up to date. With that, I will say – I will no longer be updating this site because of the frentic pace that Dave and I are updating our own respective sites. Saying ths, for more information, please go to:

Dave Wickert:
Denny Lee:


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

PowerPivot for SharePoint: Single Server Installation

August 30, 2010 by dennyglee

300px-Opening_crawlA long time ago, but not in a galaxy too far away…actually, just in Redmond, WA,… there was A NEW HOPE for easier PowerPivot for SharePoint installations! Smile

So hats off to the Analysis Services product team for building an easier PowerPivot for SharePoint installation by providing us with the “New Server” installation choice.    Yet, even with the easier installation steps, it is important to make sure you do the steps in the right order and have the correct prerequisites installed to make it a smooth installation experience.

Click through to continue reading: PowerPivot for SharePoint: Single Server Installation

How much data can I load into PowerPivot?

By powerpivotgeek (, on August 22nd, 2010

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 has an extensive array of techniques that it uses for compressing and manipulating the data. Being an in-memory database system means that the more data that we can get in . . the more data we can scan . . the more kinds of applications that we can solve. So compression is a HUGE deal for us.

Please click through to continue reading: How much data can I load into PowerPivot?

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

Howto: Get more flexibility when importing data from text files

By powerpivotgeek (, on August 18th, 2010

Question: By default PowerPivot has two limitations when working with text files (using the Office ACE OLE DB provider): (1) will only import data from files with an extension of .txt, .tab, and .csv; and (2) it will only recognize tab, comma, semicolon, space, colon, and vertical bar and column delimiters. Is there a way to change PowerPivot’s configuration so that it will recognize other file extensions or column delimiters?

To continue reading, please click through to Howto: Get more flexibility when importing data from text files

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]

Working with the 2010 Office ACE provider

By powerpivotgeek (, on August 18th, 2010

Ok. I’ve promised some best practices – here is my first one.

What is the 2010 Office ACE provider and why is this important to PowerPivot? The 2010 Office System Driver for Data Connectivity Components (aka the Office ACE provider) is a OLE DB provider that can be used to read data from and write data to Office 2010 system files such as Microsoft Access Beta (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. You can also use it to access text files.

Click through to continue reading Working with the 2010 Office ACE provider

What is a “snapshot” when you enable client-side tracing

By powerpivotgeek (, on August 2nd, 2010

In getting ready for a recent internal presentation on PowerPivot, I was asked what this button actually does . . . (see below)


The primary purpose for the settings page is to setup diagnostic tracing.

Continue Reading: What is a “snapshot” when you enable client-side tracing

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

  • RT @Coo_ray: A few facts: 1) The average delta variant positive person infects 6 people (compared to less than 3 with the original variant)… 1 hour ago
  • RT @Coo_ray: I’m an Arkansas ER physician. We are at the point warned about a year ago. There are no ICU beds in the state. 4 days ago we… 1 hour ago
  • RT @sullyfoto: For reference, here is a photo of the Enterprise Bridge with levels at near full pool. 4 hours ago
  • RT @sullyfoto: Lake Oroville is shrinking as the #drought emergency worsens in #California. In three months the lake has dropped from 42% o… 4 hours ago
  • RT @AstroKatie: 1) It already passed by harmlessly 2) It was more than 10 times farther away from us than the Moon 3) It’s so harmless NA… 6 hours ago


Copyright © 2010 Denny G Lee - All Rights Reserved