PowerPivotGeek?

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

A Peek Inside: Getting the most from data refresh

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

“Unsupported features” warning message from Excel Services

(Thanks to Ankur Goyal, one of the PowerPivot mid-tier testers, for this detailed write-up)

You might have noticed that Excel Services sometimes complains about how the PowerPivot workbook is organized. It reports an warning error like this one::

In this posting, I’ll talk about why these rectangles exist (i.e. what they do) and how you can have [...]

SharePoint Timer Service error

In another one of those “oh heck, I just spent a couple hours of my life chasing my tail” and in an effort to ‘prepare everyone for RTM’, you might notice the following error pop up from time to time.

And in the NT Event Log you might seen entries like:

An unhandled exception occurred and [...]

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