Feb 21 2020 02:38 PM
Someone please help as I have just gone into the Excel 2016 power pivot from 2013 and this update is absolute TRASH.
Why can't I add Measures and Why do I lose tables of data added into the data model?
MS Team/Excel team - Please update the Power Pivot engine as I don't have this issue with PowerBI!
Here are the many errors I get:
============================
Error Message:
============================
The operation was canceled.
----------------------------
The operation cannot be performed because another operation is in progress. Please wait for the other operation to complete and try again.
============================
Call Stack:
============================
----------------------------
at Microsoft.AnalysisServices.BackEnd.TransactionGate.StartTransaction(SandboxTransaction activeTransaction, TransactionCancellability cancellability)
at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.StartTransaction()
at Microsoft.AnalysisServices.BackEnd.SandboxTransaction..ctor(DataModelingSandbox inputSandbox, SandboxTransactionProperties properties)
at Microsoft.AnalysisServices.BackEnd.SandboxTransactionAmo..ctor(DataModelingSandboxAmo inputSandbox, SandboxTransactionProperties properties)
at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CreateInstance(DataModelingSandbox sandbox, SandboxTransactionProperties properties)
at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.CreateTransaction(SandboxTransactionProperties properties)
at Microsoft.AnalysisServices.Common.MeasureViewModelSandboxAdapter.CreateMeasure(String name, String formula)
at Microsoft.AnalysisServices.Common.MeasureViewModel.MeasureViewModelEditNodeAction.Do(IViewModelActionInstance actionInstance)
============================
THanks,
Feb 21 2020 03:02 PM