By powerpivotgeek (dwickert@microsoft.com), on October 24th, 2010
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 [...]
By powerpivotgeek (dwickert@hotmail.com), on October 4th, 2010
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on August 21st, 2010
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 [...]
By powerpivotgeek (dwickert@hotmail.com), on August 2nd, 2010
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 . [...]
By powerpivotgeek (dwickert@microsoft.com), on June 14th, 2010
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 [...]
By powerpivotgeek (dwickert@hotmail.com), on April 27th, 2010
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 [...]
By powerpivotgeek (dwickert@hotmail.com), on April 22nd, 2010
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on April 7th, 2010
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 [...]
By powerpivotgeek (dwickert@microsoft.com), on February 24th, 2010
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
By Lee Graber (leegr@microsoft.com), on January 22nd, 2010
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 [...]
Recent Comments