ExecuteXmla Error for all Encrypted PBIX on SharePoint

[3dSysAdmin]

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

[v-cazheng-msft]

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