Forum

Unable to upgrade 2...
 
Notifications
Clear all

Unable to upgrade 2010 Power Pivot data model to Excel 2013 whe Power Query connection was used in 2010 version

2 Posts
2 Users
0 Reactions
109 Views
(@rgpress)
Posts: 1
New Member
Topic starter
 

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

 
Posted : 29/08/2019 12:52 pm
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 29/08/2019 6:46 pm
Share: