So you’ve got a bunch of XML data. How do you get it into PowerPivot? Various ideas:
Import it into Excel using its normal data input capabilities. Once you’ve got the data into a worksheet, you have two options depending on if you are going to modify it later on. If the data is dynamic, [...]
So I am playing around with the PowerPivot add-in constructing a new sample application. I’ve got the data and I am inserting pivot tables in my worksheets. All of a sudden I noticed that the field list isn’t the PowerPivot field list – it is the Excel field list. What happened? (I never did figure [...]
So I am playing with importing data from an an SSAS cube. The most distracting issue is that numeric columns are imported as strings, and the default aggregation for strings is Count. Thus when I try to drag & drop measures into Values field, I found that it treated as Count rather than Sum. When [...]
“Help! My PowerPivot for Excel is totally messed up. How do I just reinstall everything?”
I’ve had to do this lots of times as we’ve gone through various beta builds. Here are the steps that I go through to totally clear out the client add-in:
Uninstall the PowerPivot for Excel add-in
Manually delete all the files under [...]
Microsoft does not recommend or support the use of Office applications in a server-side environment (see http://support.microsoft.com/kb/257757 ). In the case of PowerPivot, the data refresh facility is implemented within an NT Service and, as such, falls under this restriction. In this article we will use the ACE provider to give you more control [...]
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. The trace file itself is pretty straightforward, it is the regular SSAS tracing subsystem that we know and love . [...]
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:
Embedded Analysis Services [...]
I just had a chance to view some very cool demos on the topic of using PowerPivot and data mining together to solve some interesting business problems.
Go see Mark Tabladillo’s YouTube home page: http://www.youtube.com/user/MarkTabNet# or his web site at: http://www.marktab.net/ (which also has a download of the workbooks he is using in his demo.
And the [...]
Here is a cute trick for all of you ‘client’ jockeys out there. Sometimes you have a table that you, as a designer, have for some limited uses. Maybe the table exists for establishing relationships, or for intermediate calculations, but not for querying. How can you hide it? Well, it turns out that it is [...]
After installing the PowerPivot for Excel add-in there are various things that you can to do attempt to debug the situation:
First, and I know this sounds dumb, but I have to point it out – you have to be using Excel 2010. PowerPivot does not run under earlier version of Excel.
Next ensure that you [...]