By powerpivotgeek (dwickert@hotmail.com), on October 4th, 2010
It has been a while since I did one of the “A Peek Inside” postings and I thought “what the heck . . . do I have anything better to do while I am visiting with my in-laws during a vacation” . . . I couldn’t think of one so here goes.
PowerPivot has some special [...]
By powerpivotgeek (dwickert@hotmail.com), on September 8th, 2010
Recently there was a forum post concerning how PowerPivot parallelizes data refresh . . and I thought this might be an interesting topic for a “Peek Inside” blog posting. The first question is: Why are we doing this? What is the purpose of parallelizing data refresh? Why is this so important? Well . . there [...]
By powerpivotgeek (dwickert@microsoft.com), on May 12th, 2010
Recently I have been seeing some threads about how data is updated in a PowerPivot workbook. As it turns out, this can be a pretty complicated technical situation, so lets start off with a general statement: There are only 2 ways to update the embedded data contained in a PowerPivot workbook:
Bring the workbook down to [...]
By powerpivotgeek (dwickert@hotmail.com), on April 2nd, 2010
Recently I have been getting some questions about an earlier post that I did around how the PowerPivot inactivity unloading is done. see http://powerpivotgeek.com/2010/03/04/a-peek-inside-unloading-powerpivot-data/ for more details. Surely there must be a faster mechanism for unloading data – and there is – but to fully discuss that aspect of the system we need to take [...]
By powerpivotgeek (dwickert@microsoft.com), on March 4th, 2010
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. [...]
By powerpivotgeek (dwickert@microsoft.com), on November 25th, 2009
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on November 18th, 2009
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on November 11th, 2009
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on November 9th, 2009
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on November 7th, 2009
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 [...]
Recent Comments