Use a PowerPivot workbook in a Excel Web Access Webpart

I’ve had the question if its possible to show a PowerPivot workbook using a Excel web access webpart. The answer: Of course it is, the workbook is a regular excel workbook, so you can just point from the Excel web access webpart to a PowerPivot workbook from the powerpivot gallery. Users can interact with the PowerPivot workbook instantly as they would in a report:

The excel web part isn’t available at the PowerPivot site collection. I have created a BI site collection and added a PowerPivot Library to it. In the BI site collection we can use the excel web access webpart.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.