By powerpivotgeek (firstname.lastname@example.org), 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?
Published August 18, 2010
Configuration , Internals
Tags: ACE, FAQ, SharePoint
By powerpivotgeek (email@example.com), 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
By powerpivotgeek (firstname.lastname@example.org), on June 17th, 2010
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:
Click through to continue reading.
Published June 17, 2010
Tags: Configuration, FAQ
By powerpivotgeek (email@example.com), on June 17th, 2010
Attempting to use a modified version of the SharePoint v4.master page is a great way to style our SharePoint site. If you interested in doing this, then the first thing to do is to make sure that you go to the right place:
Click through to continue reading
May 23, 2010 by dennyglee | Edit
As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment. In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated.
PowerPivotGeek has been doing a lot of GREAT posts the last week and its getting harder and harder to keep up with greatness! Saying this, here are some great tips, how-to, and A Peek Inside!
A Peek Inside!
Published May 12, 2010
I had a great question from a customer concerning something weird happening with PowerPivot relationships. In this example, we have two tables such as city and state. With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA. Even though the relationship makes sense (as per below)
the output doesn’t!
To continue reading, click here.
Published May 12, 2010
Configuration , Perspectives , Usage
As per many blog postings, press releases, tweets, messages, and streams – PowerPivot went RTM on the 5/12. So what can or should we do now? Here’s some quick great blog postings to get yourself up and running on PowerPivot ASAP:
Published February 24, 2010
By powerpivotgeek (firstname.lastname@example.org), on February 24th, 2010
A trick for the client-side folks doing build-to-build reinstallations (or if you wish to clear all of the PowerPivot code from your client): besides uninstalling “Microsoft PowerPivot for Excel” (via control panel Add/Remove/Uninstall Programs, the exact wording varies depending on the OS you are running), you may also have to delete files in:
Published February 17, 2010
Tags: FAQ, SharePoint
For those of you who are using Windows 7 client, you should be good-to-go already because you already have Desktop Experience installed. But if you are using a Windows Server OS (e.g. Windows Server 2008, Windows Server 2008 R2), you will need to install it as part of an additional feature via the Server Manager.
Why you ask?