Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I was relating tables in power bi, I saved the file, now I can't open it again, the error appears:
"Something didn't work The relationship between column XX and column YY cannot have SecurityFilterBehavior set to BothDirection when the relationship is not set to active."
I can’t open the file!
How do I open?
Feedback Type:
Frown (Error)
Error Message:
O relacionamento entre a coluna 'HORASPAGAS' ['MED'] e a coluna 'BD PONTO'['MEDIÇÃO'] não pode ter SecurityFilterBehavior definido como BothDirections quando o relacionamento não está definido para ativo.
"Stack Trace:
Microsoft.AnalysisServices.OperationException
em Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
em Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService)
em Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
Stack Trace Message:
O relacionamento entre a coluna 'HORASPAGAS' ['MED'] e a coluna 'BD PONTO'['MEDIÇÃO'] não pode ter SecurityFilterBehavior definido como BothDirections quando o relacionamento não está definido para ativo.
Invocation Stack Trace:
em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
em Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
em Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
em Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
em Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.117.984.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.AnalysisServices.OperationException - PFE_TM_CF_RLSCF_ACTIVE_FOR_BOTH","MethodDef":"HandleError - PFE_TM_CF_RLSCF_ACTIVE_FOR_BOTH","ErrorOffset":"255"}
PowerBINonFatalError_ErrorDescription:
PFE_TM_CF_RLSCF_ACTIVE_FOR_BOTH
PowerBINonFatalError_MethodDefDescription:
PFE_TM_CF_RLSCF_ACTIVE_FOR_BOTH
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 @BrunnoMoraes ,
Do not directly open the file. Open power bi desktop and then open file. If it opens disable the join.
Increase Data Management cache to 8-10 GB before that using blank file
file-> Options & Settings -> Options.
For original post:
Solved: Unable to open PowerBI Desktop - Microsoft Fabric Community
Best regards.
Community Support Team_Caitlyn