Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I received the following error message: "Cannot have SecurityFilterBehavior set to BothDirections when the relationship is not set to active".
Detailes copied and pasted below:
Feedback Type:
Frown (Error)
Timestamp:
2023-05-17T13:18:25.6274287Z
Local Time:
2023-05-17T16:18:25.6274287+03:00
Session ID:
d6f8d8cc-7dd7-4628-a394-7b55c86a68f2
Release:
February 2023
Product Version:
2.114.864.0 (23.02) (x64)
Stack Trace:
Microsoft.AnalysisServices.OperationException
at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.<OpenFileInternal>d__40.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.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.114.864.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":"201"}
OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 528049]
Peak Virtual Memory:
66.3 GB
Private Memory:
669 MB
Peak Working Set:
828 MB
IE Version:
11.0.9600.20967
User ID:
9da59e18-64ac-4e94-9b52-5da79b13a27b
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Model Default Mode:
Empty
Model Version:
PowerBI_V1
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_enhancedTooltips
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_relationshipEditPane
PBI_setLabelOnExportPdf
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PQ_WebView2Connector
PBI_NlToDax
PBI_optimizeTabRibbon
PBI_angularRls
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
125%
Supported Services:
Power BI
Solved! Go to Solution.
@phorfanos , 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
if this does not work, log an issue too - https://community.powerbi.com/t5/Issues/idb-p/Issues
I have just gotten a new laptop and I am trying to use Microsoft PowerBI desktop on it. I successfully downloaded and installed it, but it has refused to open despite trying different versions, downloading from Microsoft store and the Microsoft website directly. I have been getting the same error message outlined below. Any help will be appreciated.
Error Message:
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
Feedback Type:
Frown (Error)
Error Message:
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
Stack Trace:
System.IO.FileNotFoundException
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.Web.WebView2.Core.CoreWebView2Environment.<CreateCoreWebView2ControllerAsync>d__80.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.Web.WebView2.WinForms.WebView2.<InitCoreWebView2Async>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2BrowserWrapper.<Initialize>d__75.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2BrowserWrapper.<ChainAfterInit>d__97.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c.<WaitOnUIThreadForTaskCompletion>b__15_0(Task t)
at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion[T](Task`1 task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion(Task task)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
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:
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
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.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
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.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.120.963.0","ModuleName":"Microsoft.Web.WebView2.Core.dll","Component":"Microsoft.Web.WebView2.Core.CoreWebView2Environment+<CreateCoreWebView2ControllerAsync>d__80","Error":"System.IO.FileNotFoundException","MethodDef":"MoveNext","ErrorOffset":"0","ErrorCode":""}
PowerBIUserFeedbackServices_IsReported:
True
@phorfanos , 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
if this does not work, log an issue too - https://community.powerbi.com/t5/Issues/idb-p/Issues
Unfortunately it happened again and it doesn't work. I mean I cannot open the pbix file no matter what. Any other way to access somehow the file change the SecurityFilterBehavior to something else but both direction?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |