Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kimloh_p
Frequent Visitor

ExecuteXmla failed with results

After upgrading to Sep 2021, unable to open PBIX files that are older and larger in filesize. It  is also unable to do a refresh of the data source. Have tried uninstall and reinstall but does not resolve the issue.

Also did not encounter this issue for the same PBIX file on another machine running on Jul 2021 version.

 

-------------------------------------------------------

ExecuteXmla failed with result

PFE_BAD_ALLOC

True

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.


at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
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.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.Main(String[] args)

1 ACCEPTED SOLUTION
kimloh_p
Frequent Visitor

thankyou for your suggestion @amitchandak , however I realised that I had installed a 32-bit version instead of a 64-bit version... hence issue is resolved now.

View solution in original post

2 REPLIES 2
kimloh_p
Frequent Visitor

thankyou for your suggestion @amitchandak , however I realised that I had installed a 32-bit version instead of a 64-bit version... hence issue is resolved now.

amitchandak
Super User
Super User

@kimloh_p , Try to reduce data in your tables.

 

Increase data management cache(8-10 GB), also make sure hard drive has sufficient free space

Load Setting.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.