Excel Power View - Sharing


Power View visualizations are interactive in nature with appealing look and feel. For any type of data and for large data sets you have suitable visualizations that will enable you to explore the data with presentable reports. So, you do not have an added step of preparing and /or previewing reports. Even formatting is interactive in nature and need not necessarily be the final step. Once you have explored and summarized your results, you would have to share with the concerned people. In this chapter, you will learn the different ways that you can share Power View reports.

Sharing Power View in Excel

You can share your Excel workbooks with Power View sheets on a SharePoint Server 2013 or SharePoint Online site. Your report readers can view and interact with the Power View sheets in the workbooks you have saved there.

Sharing Power View in SharePoint Reports

You can create and share Power View reports in SharePoint (RDLX files). The readers can view them, interact and /or edit if permissions are given on the server. Power View in Excel and Power View in SharePoint Server both provide an interactive data exploration, visualization and presentation experience for all skill levels.

You can also export an interactive version of your Power View in SharePoint report to PowerPoint. Each view in Power View becomes a separate PowerPoint slide. You can interact with the visualizations and filters in each view, but you can’t create visualizations or filters.

Printing Power View Reports

You can print a Power View sheet. However, it will be a static image on paper. It will not be an interactive report, which is innate strength of Power View. You design a Power View report, on screen, with the look and feel you have in mind, which cannot be reflected on paper. Your visualizations are meant to be dynamic and cannot be captured by static images on paper to the fullest extent.

Publishing to Power BI

You can also publish Excel workbooks with Power View sheets to Power BI. Power BI saves the Power View sheets in your workbook as a Power BI report.