FIX: Data models do not load after you run a PowerPivot scheduled data refresh job when you work with SQL Server 2014

Symptoms


Assume that you have Microsoft SQL Server 2014 installed on a computer and a PowerPivot 2014 workbook in SharePoint 2013. You run a PowerPivot scheduled data refresh job on a PowerPivot data model in the workbook. The PowerPivot data model will not load after the job runs successfully and the slicers do not work in the Excel client. When you try to open the PowerPivot add-in in the Excel client, you receive the following error message:
We couldn't load the Data Model. This may be because the Data Model in this workbook is damaged.
After you click OK, you may receive the following error message:
PowerPivot is unable to load the Data Model.

Notes:
  • The symptoms are only seen in the Microsoft Office Excel client.
  • The "scheduled data refresh job" that is described above is not the data refresh scenario in Excel.
  • This hotfix is only for the SSAS 2014 server in PowerPivot mode.

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 2 for SQL Server 2014

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.
Propriedades

ID do Artigo: 2967900 - Última Revisão: 27/06/2014 - Revisão: 1

Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Express

Comentários