Updated 28-Oct-2010: Some folks are reporting that an iisreset is needed to make the updates visible to SharePoint.
So . . . here I am playing around with PowerPivot to get ready for a demo. As this is a group from the SharePoint dev team (actually SharePoint Online), I wanted to include some cool SharePoint functionality [...]
I recently ran into this in scanning through some forum problem reports. Typically this health rule violation is reported on a large farm installation. The health rule reports the app servers that do not have PowerPivot installed on them as being out of date. Can you read “bug?” Yes, this is one. You can either [...]
If there is any error trying to load the bubble chart data for the dashboard, instead of getting a page load failure, the bubble chart simply displays a red X. Whenever you get a red X in the bubble chart there will be an associated log entry in the ULS log on the machine running [...]
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 [...]
Clearly if you read my blog, you will see that as a development team we could have done a better job of testing all of the various installation combinations with SQL Server on ‘test servers’. Unfortunately, our limited test time was focused on production configurations; not on single demo machines. So as a result you [...]
Is now available here: http://msdn.microsoft.com/en-us/library/ff976569.aspx
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 [...]
Microsoft does not recommend or support the use of Office applications in a server-side environment (see http://support.microsoft.com/kb/257757 ). In the case of PowerPivot, the data refresh facility is implemented within an NT Service and, as such, falls under this restriction. If you are using Office data within a PowerPivot workbook (e.g. importing the data [...]
(my thanks to Dan English http://denglishbi.spaces.live.com/ for the solution in this post)
Dan’s system failed trying to bring up the Workbook Activity or Server Health workbooks as part of the PowerPivot Management Dashboard in Central Admin. The error was: “The file that you selected could not be found. Check the spelling of the file name and [...]
Oh the joys of SharePoint again. I just responded to an internal posting where someone was raising the issue that “Path not found” errors were being reported when Excel Desktop tried to publish a workbook to SharePoint. Again, this isn’t PowerPivot directly, but it can be reported as a PowerPivot problem if the workbook contains [...]