PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Archives

A Peek Inside: Unloading PowerPivot data

Ok folks. Here comes a cool one.

As I am sure that everyone is aware by now, one of the most powerful new features of PowerPivot is that we do on-demand loading of embedded data. Well, if you are going to load it, then you had better at least think about unload it at some time. [...]

A Peek Inside: Why no cross-farm support?

From time to time, particular from knowledgeable SharePoint users coming up to speed with PowerPivot, I get the question: “PowerPivot have ‘cross-farm’ support”. As you can see from the title of this post, we don’t support it – and in this “A Peek Inside” I hope to explain why.

First, what is SharePoint ‘cross-farm’ support [...]

A Peek Inside: Why are domain accounts needed?

Have you ever had to do something that you knew (you just KNEW) that lots of folks were going to scream – and scream loud – about? This is one of those cases – I can just feel it!

Ok, here goes. There have been several recent newsgroups postings concerning why we require domain accounts [...]

A Peek Inside: The client architecture

Well, I have a fun one today. We get asked all of the time about how the PowerPivot add-in works. Particularly how it relates to the SSAS components that BI Pros are used to, e.g. making connections to SSAS. As I am getting ready to write an architecture overview blog posting for the PowerPivot [...]

A Peek Inside: Where’s the beef?

You have seen all of the cool demos – millions of rows of data in a single workbook. It is the hallmark of many PowerPivot keynote and session demos at conferences these days. It is way cool to see that much data being moved around so easily. The obvious question (which us technical geeks get [...]

A Peek Inside: The message stream between the client and the PWS

In the first of our “A Peek Inside” articles, let’s take an easy one. When using a client makes a connection to a PowerPivot workbook that is stored inside SharePoint, how do you suppose the connection is made? If this was a regular SQL Server Analysis Services database then there are two options: either [...]

Look for a series of ‘A Peek Inside’ articles coming soon

From the recent Q&A that I have been having with customers at the SharePoint Conference last week in Las Vegas, and this week at SQL PASS in Seattle, it is clear that there is a lot of interest in how PowerPivot works inside. Thus from time to time I am going to post a series [...]