So i requested a PowerPivot workbook from SharePoint, what happens?
In my previous blog posts we made use of a published PowerPivot workbook to use a datasource. In this post we are going to discover what goes on under the hood when you call a PowerPivot workbook on a SharePoint 2010 server. Thanks to Denny Lee from the PowerPivotTwins for reviewing this post, clearing some things up and providing excellent information.
When I make a connection with the browser to the workbook of a published xlsx by clicking the PowerPivot gallery the following things happen:
- The Excel web access service starts rendering the workbook
- It will connect to Excel Calculation Services which will extract the workbook from the SharePoint content dB
Tags: sharepoint