Home

Power Pivot Critical failures - Measures

%3CLINGO-SUB%20id%3D%22lingo-sub-1188206%22%20slang%3D%22en-US%22%3EPower%20Pivot%20Critical%20failures%20-%20Measures%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188206%22%20slang%3D%22en-US%22%3E%3CP%3ESomeone%20please%20help%20as%20I%20have%20just%20gone%20into%20the%20Excel%202016%20power%20pivot%20from%202013%20and%20this%20update%20is%20absolute%20TRASH.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20can't%20I%20add%20Measures%20and%20Why%20do%20I%20lose%20tables%20of%20data%20added%20into%20the%20data%20model%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMS%20Team%2FExcel%20team%20-%20Please%20update%20the%20Power%20Pivot%20engine%20as%20I%20don't%20have%20this%20issue%20with%20PowerBI!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20many%20errors%20I%20get%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3CBR%20%2F%3EError%20Message%3A%3CBR%20%2F%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3EThe%20operation%20was%20canceled.%3CBR%20%2F%3E----------------------------%3CBR%20%2F%3EThe%20operation%20cannot%20be%20performed%20because%20another%20operation%20is%20in%20progress.%20Please%20wait%20for%20the%20other%20operation%20to%20complete%20and%20try%20again.%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3DCall%20Stack%3A%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E----------------------------%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.TransactionGate.StartTransaction(SandboxTransaction%20activeTransaction%2C%20TransactionCancellability%20cancellability)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.SandboxTransaction.StartTransaction()%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.SandboxTransaction..ctor(DataModelingSandbox%20inputSandbox%2C%20SandboxTransactionProperties%20properties)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.SandboxTransactionAmo..ctor(DataModelingSandboxAmo%20inputSandbox%2C%20SandboxTransactionProperties%20properties)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CreateInstance(DataModelingSandbox%20sandbox%2C%20SandboxTransactionProperties%20properties)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.CreateTransaction(SandboxTransactionProperties%20properties)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.Common.MeasureViewModelSandboxAdapter.CreateMeasure(String%20name%2C%20String%20formula)%3CBR%20%2F%3Eat%20Microsoft.AnalysisServices.Common.MeasureViewModel.MeasureViewModelEditNodeAction.Do(IViewModelActionInstance%20actionInstance)%3C%2FP%3E%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1188206%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1188238%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20Critical%20failures%20-%20Measures%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1188238%22%20slang%3D%22en-US%22%3EHello%2C%20kindly%20make%20the%20question%20clear.%20Didn't%20try%20what%20you%20mean%20by%20you've%20gone%20into%202016%20Power%20Pivot%20from%202013..%20That's%20not%20clear..%20We%20need%20to%20know%20exactly%20which%20version%20of%20Excel%20you%20have%20issue%20with..%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20one%20that%20is%20not%20clear%20is%2C%20%22I%20can't%20add%20measures%20and%20Why%20do%20I%20lose%20tables%20of%20data%20added%20into%20the%20data%20model%3F%22%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20that%20you're%20unable%20to%20create%20Measures%20in%20the%20Measure%20Grip%20of%20Power%20Pivot%20or%20from%20PowerPivot%20PivotTable%20field%20by%20right-click%20and%20select%20Add%20Measure%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20you%20add%20data%20formatted%20in%20Excel%20Table%20into%20the%20Add%20Model%2C%20definitely%2C%20the%20added%20data%20will%20be%20visible%20in%20the%20Power%20Pivot%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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,

1 Reply
Highlighted
Hello, kindly make the question clear. Didn't try what you mean by you've gone into 2016 Power Pivot from 2013.. That's not clear.. We need to know exactly which version of Excel you have issue with..

Another one that is not clear is, "I can't add measures and Why do I lose tables of data added into the data model?"

Is it that you're unable to create Measures in the Measure Grip of Power Pivot or from PowerPivot PivotTable field by right-click and select Add Measure?

When you add data formatted in Excel Table into the Add Model, definitely, the added data will be visible in the Power Pivot
Related Conversations
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Problem sorting Pivot Table according to date
MikkoS in Excel on
1 Replies
Pivot table displaying percentage
pritish9 in Excel on
0 Replies