Unable to upgrade 2010 Power Pivot data model to Excel 2013 whe Power Query connection was used in 2010 version|Power Pivot|Excel Forum|My Online Training Hub

Hi

I have several Excel 2010 POwer Pivot workbooks suing power query to capture data as a data connection. My company just updated to Excel 2013. When I open one of the Excel 2010 files in 2013, if I have not used power query to captur the data, there is no problem updating the data model and using power pivot. If I attempt to open a file that has used power query to capture data, I am asked to update the power pivot data model, but the update data model process fails with the following error:

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

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

at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.AddDataSourceModifiedAnnotation(String dataSourceId)
at Microsoft.AnalysisServices.Common.ServerUpgradeManager.UpgradeKillimanjaroToO15(DataModelingSandbox sandbox, GetCustomXMLPartsDelegate getCallbackMethod, BackgroundWorker worker)
----------------------------
at Microsoft.AnalysisServices.Common.ServerUpgradeManager.UpgradeKillimanjaroToO15(DataModelingSandbox sandbox, GetCustomXMLPartsDelegate getCallbackMethod, BackgroundWorker worker)
at Microsoft.Office.PowerPivot.ExcelAddIn.SandboxVersionManager.UpgradeSandbox(DataModelingSandbox sandbox, BackgroundWorker worker)
at Microsoft.Office.PowerPivot.ExcelAddIn.SandboxVersionManager.UpgradeWorkbook(GeminiWorkbook geminiWorkbook, BackgroundWorker worker)

I would greatly appreciate any information on this, when googling this error only a few items come up, and no solutions. I have tried disconnecting the poer query data source, but no joy there.

Thanks

Bob