Forum Discussion

mbrt's avatar
mbrt
New Member
4 years ago

Power Pivot - Unhandled Exception

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.

Need Help

2 Replies

  • edhans's avatar
    edhans
    Community Champion
    4 years ago

    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's avatar
      mbrt
      New Member
      4 years ago

      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!