Power Pivot - Unhandled Exception

[mbrt]

Hi All,

I have one report I am updating for 1+ years and always worked fine.

Unfortunately, since a couple of weeks whenever I try to refresh power pivot, the model fails and return this error

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

Specified method is not supported.

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

   at Microsoft.AnalysisServices.Common.TableWidgetGridControl.UpdateWidgetTags()
   at Microsoft.AnalysisServices.Common.TableWidgetGridControl.InitializeGridLayout(Boolean isReset)
   at Microsoft.AnalysisServices.Common.TableWidgetGridControl.SetStorageTable(ITableDataView value, Stream stream)
   at Microsoft.AnalysisServices.Common.SandboxEditor.ConnectTableWidgetData(TableWidgetPanel tableWidgetNew, TableWidgetViewModel tableWidgetViewModel, TableWidgetViewModelSandboxAdapter tableWidgetViewModelSandboxAdapter, DataModelingTable table)
   at Microsoft.AnalysisServices.Common.SandboxEditor.InitializeTableWidget(TableWidgetPanel tableWidgetNew, TableWidgetViewModel tableWidgetViewModel, TableWidgetViewModelSandboxAdapter tableWidgetViewModelSandboxAdapter, DataModelingTable table)
   at Microsoft.AnalysisServices.Common.SandboxEditor.LoadTableWidgetPanel(SandboxEditorTableWidgetViewModelKey key, DataModelingTable table, Boolean forceViewModelRefresh)
   at Microsoft.AnalysisServices.Common.SandboxEditor.PopulateTableWidget(String tableId)
   at Microsoft.AnalysisServices.Common.SandboxEditor.sheetsTab_sheetChanged(Object sender, EventArgs e)
   at Microsoft.AnalysisServices.Common.SheetTabs.SetSelectedSheetInternal(String key)
   at Microsoft.AnalysisServices.Common.SheetTabs.PopulateSheetListUI(String keyOfNewSheetToSelect, Boolean toRecreateUIElements)
   at Microsoft.AnalysisServices.Common.SheetTabs.SetSelectedSheet(String key)
   at Microsoft.AnalysisServices.Common.SandboxEditor.RefreshSandboxEditor(String tableId)
   at Microsoft.AnalysisServices.XLHost.Modeler.ClientWindow.RefreshClientWindow(String tableName)

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

The error persists on old versions of the file and even if I am not refreshing any query [using the same data that always worked].

Any suggestion would be appreciated!

Thank you, Umberto.

[edhans]

I would open a support ticket. I suspect a minor bug was introduced in a recent update. I assume you are on Office 365.

If not - and you haven't updated Excel in a while, then try to find an old version of the file. There may be a corruptoin in the current one.

[mbrt]

Thanks edhans!

Yes, I am on 365 with the most updated version of Excel; I tried to use some older versions, but they all had the same issue.

Will open a support ticket too!