Issues - Power Bi - Connect Tables

[BrunnoMoraes]

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

"

[Anonymous]

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

[BrunnoMoraes]

Hi v-xiaoyan-msft,

I increased the data management cache to 8-10GB before that using a blank file.

But it still didn't open.

Please, Help me!

Thks