Welcome to Day 4 of this series on Visualizing the Olympics with Power View in Excel 2013. In yesterday’s post we looked at how you can add embedded images to the PowerPivot model that is present in Excel whenever you are using Power View content.
Worth noting on its own, The PowerPivot in-memory engine (also known as xVelocity) is now fully integrated into Excel with Excel 2013. As a result, whenever you create a Power View report in Excel or whenever you create a PivotTable that is based on multiple tables in Excel (a very cool new feature in Excel if I may add), behind the scenes a PowerPivot model is generated in the workbook.
For today’s post, we are going to look at how you can save your workbooks to Office 365 and then interact with them in desktop browsers. To take advantage of this capability when you sign up for the Office Consumer Preview, choose the Office 365 Enterprise offering.
Once you sign up for Office 365 and download the Excel 2013 Consumer Preview, you will then be able to create a Sharepoint site such as the one displayed below:
As you can see, I now have a document library on my team site here in Office 365. You can simply drag and drop your workbook to the document library, but once it is there, all you have to do is click on it and it opens in the browser using the Microsoft Excel Web App Preview.
The workbook is now being displayed in the browser and our Power View content is fully interactive. I can continue to change the sport I want to look at on the map by simply clicking on one of the images that we set up in yesterday’s post. The filter pane is also available.
Right now there are a couple of restrictions that you will need to be aware of in the Office 365 setting. The first is that all of the data must be in the internal Power Pivot model that is part of the workbook. While it is possible to connect directly to Analysis Services Tabular Models that are deployed on an Analysis Services server, this feature is not yet available in the Office 365 setting. The second limitation right now is that the workbooks must be 5 10 MB in size or less. While that may not seem like a lot of data, we have examples running where we have managed to store more than one million records in PowerPivot that fit within this size restriction.