Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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.


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

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!