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 wanted to consolidate all of these into a single posting:
Roadmap to Creating PowerPivot Workbooks in Excel: http://technet.microsoft.com/en-us/library/ee210641.aspx
PowerPivot for Excel Tutorial: http://technet.microsoft.com/en-us/library/ee835510.aspx
PowerPivot for Excel Samples: http://go.microsoft.com/fwlink/?LinkID=192753&clcid=0×409
PowerPivot for Excel DAX Samples: http://go.microsoft.com/fwlink/?LinkID=192754&clcid=0×409
For those interested, I’ve been able to get some of the PowerPivot demos running again. Here is a quick status:
Contoso Retail Warehouse workbook: RUNNING!
NFL Stats: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
USDA Analysis: (not yet – it points to the PowerPivot Gallery where the demos are stored!)
NBA Stats: [...]
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 [...]
As more and more folks start to get into PowerPivot and SharePoint, there is a need to programmatically write entries into the ULS. Since all of PowerPivot and all of SharePoint share this common logging infrastructure, why not also include log entries from your own processes. Here is some sample code for doing that:
First via [...]