Executexmla failed with result

[Anonymous]

Receving "Executexmla failed with result" error.  Other colleagues with identical access do not have this issue.  See details below.

Feedback Type:

Frown (Error)

Timestamp:

2021-03-04T20:01:17.0028600Z

Local Time:

2021-03-04T15:01:17.0028600-05:00

Session ID:

58a44e8a-7719-4d8c-b8ed-6d40d27206c3

Release:

May 2020

Product Version:

2.81.5831.1181 (20.05) (x86)

Stack Trace:

   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla)

   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<>c__DisplayClass41_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 Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()

   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:

{"AppName":"PBIDesktop","AppVersion":"2.81.5831.1181","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException","MethodDef":"ExecuteXmla","ErrorOffset":"112"}

InnerException0.Stack Trace:

OS Version:

Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:

4.7 or later [Release Number = 528049]

Peak Virtual Memory:

968 MB

Private Memory:

234 MB

Peak Working Set:

222 MB

IE Version:

11.1790.17763.0

User ID:

d08667b1-58ba-44f3-91c5-ae479463420c

Telemetry Enabled:

True

DPI Scale:

125%

Supported Services:

Power BI Report Server,  Power BI

[Anonymous]

Were you able to find a resolution to your issue? I'm facing the same thing. 

[v-chuncz-msft]

@Anonymous 

Uninstall the program and try the latest version of Power BI Desktop.

[Anonymous]

We have this same issue with Pbix files. Issues started when Power BI latest version was installed last friday 26th of Feb. Version what we have is Version: 2.90.782.0 64-bit (February 2021)

[Anonymous]

SOLUTION FOUND:

It appeared the issue may have been a running a 32-bit PowerBI on a 64-bit system. After going through IT to update from the May 2020 version of PowerBI (32 bit) to the January 2021 version of PowerBI (64 bit), I was able to open the file.

Although now I am unable to upload PowerBI files to the reporting server, so that's a new issue!! 🙂