Power Bi desktop File Error

[Aafsalesbi]

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

[v-yetao1-msft]

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