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 [...]
By powerpivotgeek (dwickert@microsoft.com), on November 7th, 2009
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 [...]
Recent Comments