The Excel Web Client displays the Power View placeholder icon

Symptoms

Consider the following:
  • You have a SharePoint 2013 Enterprise Edition website.
  • You have uploaded Power View-enabled Excel 2013 workbooks to the Power Pivot Gallery.
  • You open the workbooks in the browser by using the Excel 2013 Web Client.

In this scenario, when you view the Power View sheet, you see a generic, static Power View placeholder icon instead of being able to view and manipulate the Power View report.

Cause

This issue occurs when a workbook is opened by using Office Web Apps and not Excel Services. Examine the URL of the workbook to determine whether this is the case. If the URL in the browser contains WopiFrame.aspx, then the workbook is being opened by using Office Web Apps and therefore,, Power View is not supported.

For more information about which SharePoint 2013 and Excel combinations support Power View, go to the following Microsoft website:

Resolution

If you only have Office Web Apps enabled, you will have to enable Excel Services for the Power View sheet to be made visible and interactive.

In order to enable Excel Services, you must have the Enterprise Edition of SharePoint 2013. If you do not have this edition, you cannot enable viewing or manipulation of the Power View sheet in the Excel Web Client. You will therefore have to use the Excel Desktop Client.

If you have both Excel Services and Office Web Apps on the SharePoint server, you can change a setting in SharePoint to make Excel workbooks render by using Excel Services instead of Office Web Apps. To do this, follow these steps:

  1. On the computer that has SharePoint installed, run the SharePoint 2013 Management Shell as an admin.
  2. Type the following PowerShell cmdlet, and then press Enter:

    New-SPWOPISuppressionSetting -extension xlsx -action view 
For more information about New-SPWOPISuppressionSetting, go to the following Microsoft website:

New-SPWOPISuppressionSetting
Properties

Article ID: 2969251 - Last Review: 22 Jul 2014 - Revision: 1

Feedback