Forum Discussion
Unable to open PowerBI Desktop
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
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
3 Replies
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?
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
