PowerPivotGeek?

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

General problems with Gallery snapshots not being taken – no items listed in the ULS log

For most problems with the Gallery snapshot problem, there are entries in the ULS – but sometimes there are no items or if there are, there is just the “Timeout Exception”. Under these circumstances there is so little to go on that it is hard to figure out how to even get started. Here are [...]

SharePoint 2010 Developer Dashboard

I having been playing around with a new SharePoint 2010 feature called the Developer Dashboard. It is a great tool to use when figuring out how your pages work behind the scenes.

See some previous postings on the topic here: http://blogs.technet.com/b/speschka/archive/2009/10/28/using-the-developer-dashboard-in-sharepoint-2010.aspx http://powerpivotgeek.com/2010/05/18/enabling-the-sharepoint-developer-dashboard/

To disable the Developer Dashboard:

STSADM.exe –o setproperty –pn [...]

SharePoint 2010 revised ULSViewer

From time to time I get questions from folks asking me “What is the best debugging tool for PowerPivot?” – The Answer is that there is clear cut favorite and it is EXTREMELY useful, but I didn’t know that it was released to the public. Well . . . after some investigation, it looks like [...]

What is a “snapshot” when you enable client-side tracing

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

Why is allocation always selecting the same machine?

If you are running PowerPivot for SharePoint on more than one backend app server, then it is a common issue that folks are seeing only one server being used. It turns out that this might be ‘by-design’ so let’s talk about it for a bit. Let’s look at the two allocation methods we support:

Round-robin (the [...]

Querying data within the PowerPivot Excel client add-in

Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:

The result set must have a name associated with each column. If you are not returning the column [...]

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

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

A new Diagnostic Guide posted in the Troubleshooting section

I just posted a new diagnostic guide in the troubleshooting section:

“Diagnostic Guide for Usage and the PowerPivot Management Dashboard” by Ankur Goyal
http://powerpivotgeek.com/troubleshooting/diagnostic-guide-for-usage-and-the-powerpivot-management-dashboard/

Enjoy!

_-_-_ Dave

How to start debugging a PowerPivot for SharePoint installation issue

A number of people have had issues with PowerPivot installation failures in CTP3. Hopefully, we have resolved all of these for RTM, but I can tell you that setup is still a bit tricky. To give you something of an understanding, the “New Farm” installation option is responsible for getting your machine up and running [...]