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
Hi Bob,
This will be because in Excel 2010 Power Query couldn't load the data directly to the data model/Power Pivot, whereas in Excel 2013 the path from Power Query to Power Pivot is different. I'm not aware of any workaround, sorry.
Mynda