Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hai ,
Need an assist with below error,
I can't open this Power bi desktop file now
Feedback Type:
Frown (Error)
Error Message:
You cannot add the calculated column 'GrSalesValue' to the hybrid table 'Invoice Detail'. Please remove the calculated column.
Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, IFileManager fileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__3()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Stack Trace Message:
You cannot add the calculated column 'GrSalesValue' to the hybrid table 'Invoice Detail'. Please remove the calculated column.
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.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.112.1161.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - UNKNOWN_ERROR: 0xC141016A","MethodDef":"HandleError - UNKNOWN_ERROR: 0xC141016A","ErrorOffset":"201"}
PowerBINonFatalError_ErrorDescription:
UNKNOWN_ERROR: 0xC141016A
PowerBINonFatalError_MethodDefDescription:
UNKNOWN_ERROR: 0xC141016A
PowerBIUserFeedbackServices_IsReported:
True
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Aafsalesbi
According to your error message , you are adding a calculated column to the mixed table , which causes the error to be reported . Is this calculated column mentioned in the error report added in the data source , or is it added when creating the report ? If you delete this calculated column , can you open the report normally ?
Best Regards,
Community Support Team _ Ailsa Tao