V 3.0.4 Display Error when using a value in columns

[charlottew-star]

Hi, We have been using this for a while, but recently some visuals are showing an error. If I remove the value in columns the data displays and we have still been able to export the data from this visual (with column) so we know the data is loaded. Any ideas on this, I see version 3.0.4 is newer than the current version displayed on your site, not sure if this latest release has affected this.

Thanks

[toresenneseth]

Hi,

Can you post the error message you get when you click "Copy details"?

The error dialog you are seeing comes from Power BI, not from our visual. Are you using SSAS multidimensional cube as a data source?

[charlottew-star]

Yes using SSAS multidimensional cube.

Feedback Type: Frown (Error)

Timestamp: 2020-11-10T18:25:39.2078839Z

Local Time: 2020-11-11T07:25:39.2078839+13:00

Session ID: d40cb1ad-74b9-4514-841d-9b2f3e89ec17

Release: October 2020

Product Version: 2.86.902.0 (20.10) (x64)

Error Message: Couldn't retrieve the data for this visual. Please try again later.

Stack Trace: System.InvalidOperationException: Could not resolve Field Inverse_CM_Forecast_Amount from table 2 at Microsoft.DataShaping.Contract.FailCore(String msg) at Microsoft.DataShaping.Processing.Reconciliation.ResultTableLookup.GetFieldIndex(String fieldId, Int32 tableIndex) at Microsoft.DataShaping.Processing.Reconciliation.ExpressionReconciler.Visit(FieldValueExpressionNode node) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(Calculation calculation) at Microsoft.DataShaping.Processing.Reconciliation.ReconciliationUtils.ReconcileWritable[TDSD,TRDSD](IList1 dsdItems, Func2 reconcileFunc) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(DataIntersection intersection) at Microsoft.DataShaping.Processing.Reconciliation.ReconciliationUtils.ReconcileWritable[TDSD,TRDSD](IList1 dsdItems, Func2 reconcileFunc) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(DataMember member) at Microsoft.DataShaping.Processing.Reconciliation.ReconciliationUtils.ReconcileWritable[TDSD,TRDSD](IList1 dsdItems, Func2 reconcileFunc) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(DataMember member) at Microsoft.DataShaping.Processing.Reconciliation.ReconciliationUtils.ReconcileWritable[TDSD,TRDSD](IList1 dsdItems, Func2 reconcileFunc) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(DataMember member) at Microsoft.DataShaping.Processing.Reconciliation.ReconciliationUtils.ReconcileWritable[TDSD,TRDSD](IList1 dsdItems, Func2 reconcileFunc) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.Reconcile(DataShape dataShape) at Microsoft.DataShaping.Processing.Reconciliation.DataShapeDefinitionReconciler.ReconcileInternal(DataShapeDefinition dsd) at Microsoft.DataShaping.Processing.DataShapeProcessor.d1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.d9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.DataShaping.Engine.DataShapeProcessingHost.d2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.DataShaping.Engine.DataShapeEngine.d7.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.DataShaping.Common.TaskUtils.WaitAndUnwrap(Task task) at Microsoft.PowerBI.ExploreHost.DataShapeEngineHost.ExecuteSemanticQuery(IDataShapeEngine engine, SemanticQueryDataShapeCommand command, EngineDataModel engineDataModel, IExecuteSemanticQueryResultWriter writer, IConnectionPool connectionPool, IDataShapingDataSourceInfo dsDataSourceInfo, DataReductionConfiguration dataReductionConfig, IConnectionUserImpersonator connectionUserImpersonator, ITelemetryService telemetryService, QueryExecutionOptions queryExecutionOptions, Int32 queryId, CancellationToken cancelToken, IFeatureSwitchProvider featureSwitchProvider, IAnalyticsFeatureSwitchProvider analyticsFeatureSwitchProvider) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQuery(IQueryResultDataWriter queryResultDataWriter, EngineDataModel engineDataModel, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode, CancellationToken cancelToken) at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, IList1 queries, HashSet1 pendingQueriesToCancel, EngineDataModel engineDataModel)

Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.ErrorHostService.GetErrorDetails(ShowErrorDialogArgs args) at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>cDisplayClass3_1.b1() at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state) at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action) at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>cDisplayClass3_0.<b0>d.MoveNext() at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine) at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>cDisplayClass3_0.b0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>cDisplayClass1_0`1.b0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>cDisplayClass0_1.b0(Object null) at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>cDisplayClass4_0.

b1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args)

OS Version: Microsoft Windows NT 10.0.16299.0 (x64 en-US)

CLR Version: 4.7 or later [Release Number = 461814]

Peak Virtual Memory: 34.1 GB

Private Memory: 487 MB

Peak Working Set: 668 MB

IE Version: 11.2166.16299.0

User ID: e906f0c3-bc45-4135-8277-7dd2b074155e

Workbook Package Info: 1* - en-NZ, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled: True

AS Live Connection: True

Performance Trace Logs: --\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features: PBI_NewWebTableInference PBI_v3ModelsPreview

Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_JsonTableInference PBI_ImportTextByExample PBI_ExcelTableInference PBI_qnaLiveConnect PBI_dataSearchCuration PBI_azureMapVisual PBI_dataPointLassoSelect PBI_narrativeTextBox PBI_dynamicParameters

Disabled DirectQuery Options: TreatHanaAsRelationalSource

Cloud: GlobalCloud

DPI Scale: 100%

Supported Services: Power BI

Formulas:

section Section1;

[toresenneseth]

The Power BI query engine for custom visuals has a bug and does not handle SSAS multidimensional cubes. We assume it's because they are not able to translate correctly from DAX to MDX, but we're not sure. We have reported the issue to Microsoft, but they have not fixed it yet.

Issue also #123 refers to the same problem. We're not sure, but a reason that Microsoft might not prioritize this issue is that they seem to deprecate SSAS MD as a supported data source in Power BI in favor of SSAS Tabular.

[charlottew-star]

Ok thanks for the response