Power Pivot - Cannot update the Data Model

Question

I am trying to open a Data Model in PowerPivot. The model was created in a previous version of PowerPivot, and I get a prompt to upgrade the Data Model.

Trying to do this upgrade gives the following error message:

Excel couldn't upgrade the Data Model in this workbook. It's been reverted to the previous version.

============================ Error Message:

Exception of type 'Microsoft.AnalysisServices.BackEnd.PQDataSourceAnnotationByPPException' was thrown.

Exception of type 'Microsoft.AnalysisServices.BackEnd.PQDataSourceAnnotationByPPException' was thrown.

============================ Call Stack:

at Microsoft.AnalysisServices.BackEnd.DataModelingDataSource.SetIsModifiedInPP() at Microsoft.AnalysisServices.Common.ServerUpgradeManager.UpgradeKillimanjaroToO15(DataModelingSandboxAmo sandboxImpl, GetCustomXMLPartsDelegate getCallbackMethod, BackgroundWorker worker)

at Microsoft.AnalysisServices.Common.ServerUpgradeManager.UpgradeKillimanjaroToO15(DataModelingSandboxAmo sandboxImpl, GetCustomXMLPartsDelegate getCallbackMethod, BackgroundWorker worker)
at Microsoft.Office.PowerPivot.ExcelAddIn.SandboxVersionManager.UpgradeSandbox(DataModelingSandboxAmo sandbox, BackgroundWorker worker)
at Microsoft.Office.PowerPivot.ExcelAddIn.SandboxVersionManager.UpgradeWorkbook(GeminiWorkbook geminiWorkbook, BackgroundWorker worker)

============================

Tried a few thing but nothing gets past this. I confirmed this is an issue on separate machines.

Answer 1

Could you share us a test file without sensitive information to reproduce your issue?

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.