PowerPivotGeek?

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

Using a SharePoint list as a data source

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

Pointers: Samples and Tutorials

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

Enjoy!

_-_-_ Dave

PowerPivot.com demos are running again

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

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

Howto: Write to the ULS

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