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.
Hi,
We use Windows Information Protection (WIP) with our SharePoint installation (effectively encrypting all files on a user's computer that is synced with a SharePoint site). When attempting to open any PBIX file that is saved on SharePoint, we run across this error "ExecuteXmla failed with result". We have to save this file locally, un-encrypt, edit, then overwrite back onto SharePoint.
As an Intune Administrator, we have setup PowerBI to be WIP Protected and have confirmed via Task Manager that PBIDesktop.exe runs in the enterprise context. See below for the XMLA error and system details. We've also setup the app.powerbi.com as an allowed site to the network boundary for WIP.
I've seen several posts that say that all ExecuteXmla errors should be resolved by updating PowerBI to the latest version. I'm on the october release and am facing this issue. Furthermore, this is the only support/guidance given by the troubleshooting guide for opening "encrypted files" in PowerBI.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-error-launching-desktop
NOTE: I cannot upload an example of an encrypted file protected by WIP - my system will not allow me to do so. Please see images attached; its unknown whether this problem can be replicated outside of a WIP-protected device.
Any other PowerBI users out there who can work with Encrypted PBIX files?
Feedback Type:
Frown (Error)
Error Message:
ExecuteXmla failed with result
Stack Trace:
Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<>c__DisplayClass45_0.<ImageLoadDatabaseFromPbix>b__0()
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.OnErrorClarify(Action action, String clarification)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
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:
ExecuteXmla failed with result
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__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.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.98.683.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException - PFE_MANAGED_ZIPLOAD_UNEXPECTED","MethodDef":"ExecuteXmla - PFE_MANAGED_ZIPLOAD_UNEXPECTED","ErrorOffset":"112"}
InnerException0.Stack Trace Message:
Access to the path 'C:\Users\{USERNAME}\{SHAREPOINT DIR}\Software - Management - Documents\Other\01. BizOps\01. PowerBI Reports\20200818 Quarterly Report.pbix' is denied.. An error occurred while reading a compressed file.
InnerException0.Stack Trace:
InnerException0.Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
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__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError_ErrorDescription:
PFE_MANAGED_ZIPLOAD_UNEXPECTED
PowerBINonFatalError_MethodDefDescription:
PFE_MANAGED_ZIPLOAD_UNEXPECTED
PowerBIUserFeedbackServices_IsReported:
True
Feedback Type:
Frown (Error)
Timestamp:
2021-10-20T22:19:41.1759536Z
Local Time:
2021-10-20T17:19:41.1759536-05:00
Session ID:
19c3391f-d577-477f-806f-0f08a7cac3f7
Release:
October 2021
Product Version:
2.98.683.0 (21.10) (x64)
OS Version:
Microsoft Windows NT 10.0.19043.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528372]
Peak Virtual Memory:
103 GB
Private Memory:
689 MB
Peak Working Set:
882 MB
IE Version:
11.789.19041.0
User ID:
c9d7a494-1661-41bc-a871-57cf1ecebf80
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\{USERNAME}\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShota59f7457-298a-4320-8cb4-c1b12f4093d6.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\{USERNAME}\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_rdlNativeVisual
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PBI_enableWebView2
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @3dSysAdmin
Did you configure your WIP for Power BI Desktop and SharePoint according to this document Create a Windows Information Protection (WIP) policy with MDM using the Azure portal for Microsoft I...?
Best Regards,
Community Support Team _Caiyun Zheng