PowerPivotGeek?

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

Archives

Tip: You must use a 32-bit browser when running on a 64-bit client

This will save you a few hours of debugging. Virtually every SharePoint feature and application, e.g. Excel, PPT, and Word Web Apps, do not support 64-bit browsers. In order to work around this behavior, please use a 32-bit browser. While others have issues around compatibility, this restriction applies to PowerPivot for one HUGE reason. And [...]

PowerPivot architecture at a glance (albeit a *large* glance)

The SQLCAT team just posted the first in what I hope will be a series of PowerPivot architecture posters. This one provides an overview of all of the moving parts in a PowerPivot system. It started small and grew and grew. We knew that we wanted a complete picture and we decided to use all [...]

Bug: Management Dashboard .odc file is broken

OK, here is our first ‘bug’. As part of the PowerPivot Management Dashboard, we ship a .odc file that is used to point to the PowerPivot dashboard data workbook (the data you see in the dashboard reports). You can click on the .odc file and Excel desktop will popup pointing to the dashboard data. Unfortunately [...]

Why PowerPivot requires ‘classic-mode’ web applications

SharePoint 2010 has a new ‘claims-based’ authentication system that allows you to use federated identities with SharePoint. And there are certainly some customers that are excited to start playing around with this capability. That is neat and cool and all . . . but that isn’t the major reason why folks should be getting excited [...]

Howto: Write to the ULS

As more and more folks start to get into PowerPivot and SharePoint, there is a need to programmatically write entries into the ULS. Since all of PowerPivot and all of SharePoint share this common logging infrastructure, why not also include log entries from your own processes. Here is some sample code for doing that:

First via [...]

Giving remote users rights to log on to your domain controller

For all of you that are running a combined all-in-1 system, i.e. domain controller, SharePoint and all of PowerPivot (desktop + server), you will notice that if you are trying to debug with non-administrator accounts that you can no longer remote desktop on to your machine. This is because by default only administrators are allowed [...]

Help: c2wts has fallen and it cannot get up

(This applies to the RTM version of SharePoint and is an extremely common problem that is occurring with all of our RTM servers. I think that it will quickly become one of those things that everyone does each and every time they install a SharePoint server.)

There are two reasons why the “Claims to Windows Token [...]

Working with the 2010 Office ACE provider

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 [...]

A Peek Inside: Allocation. What is it? Why is it important?

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 [...]

PowerPivot and Windows 7

Recently I had a conversation with one of our excellent beta testers and I want to make sure that everyone was clear about running PowerPivot on Windows 7.

Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint