How to manually update your PowerPivot Management Dashboard

By powerpivotgeek (, on January 18th, 2010

We have gotten lots of feedback about the new CTP3 PowerPivot Management Dashboard feature. Most folks are excited about the new reports and can see how the reports give you an unparalleled ability to ‘peek’ inside the running services. However the default “wait-a-day” update cycle can see a bit long. A day-long cycle period seems OK for long-term analysis of data, but for demoing the system and investigating how to use the capabilities work you might want a shorter cycle, or want the ability to refresh the data during the day. This post is all about how you do that.

First, you have to determine if the Usage file collection is long enough for you to wait. By default, it takes 30 minutes for your actual usage of the system (clicking here; clicking there) actually end up in a Usage file. If you can wait 30 minutes, then leave the system as it is. If you need usage information sooner, then you will need to tweak two settings:

 Read more…


2 Responses to “How to manually update your PowerPivot Management Dashboard”

  1. 1 Will October 5, 2010 at 12:02 am

    I’d like to see the reports! The only problem I have is the only timer job I have associated with PowerPivot on my server is the PowerPivot Refresh Timer job. I don’t see one for the management dashboard at all. Do you have any advice for fixing that?

    • 2 dennyglee October 7, 2010 at 6:49 pm

      Apologies for the delay in response, I noticed you had pinged the original @PowerPivotGeek post which is the better location for those questions anyways, eh?!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Denny Lee’s Tweets (1/2 of PowerPivot Twins!)


Copyright © 2010 Denny G Lee - All Rights Reserved

%d bloggers like this: