FIX: PowerPivot Gallery unexpectedly displays the Create Power View Report button when you use SSAS 2014 as a data source

Symptoms

Consider the following scenario:
  • You create a PivotTable report in a Microsoft Excel workbook by importing data from Microsoft SQL Server 2012 Analysis Services (SSAS 2014).
  • You upload the Excel workbook to a PowerPivot Gallery in SharePoint Server 2013.
  • You open the PowerPivot Gallery.
In this scenario, the Create Power View Report button in the upper-right corner of the Excel workbook is visible and enabled, even though the workbook does not contain a data model. Additionally, when you click the Create Power View Report, you receive the following error message:

An error occurred while loading the model for the item or data source "<path>"
Verify that the connection information is correct and that you have permissions to access the data source.

Resolution

The issue was first fixed in the following SQL Server cumulative updates: 

Cumulative Update 8 for SQL Server 2014

Cumulative Update 1 for SQL Server 2014 SP1
About cumulative updates for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 3053752 - Last Review: Jun 22, 2015 - Revision: 1

Feedback