Frown (Error)

[KS_B]

Dear Team,

Please help in resolving the following error; 

Feedback Type:
Frown (Error)

Timestamp:
2023-09-25T09:01:56.2671774Z

Local Time:
2023-09-25T10:01:56.2671774+01:00

Session ID:
32a7f82d-eca4-47fd-8f66-8733f0839d9a

Release:
September 2023

Product Version:
2.121.762.0 (23.09) (x64)

Stack Trace:
System.Runtime.InteropServices.SEHException
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
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)

Error Code:
-2147467259 (0x80004005)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.121.762.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Shared.WindowManager","Error":"System.Runtime.InteropServices.SEHException","MethodDef":"ShowModal","ErrorOffset":"70","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533325]

Peak Virtual Memory:
70.6 GB

Private Memory:
764 MB

Peak Working Set:
1.2 GB

IE Version:
11.789.19041.0

User ID:
5e7d0738-fa72-43f8-83b7-e1f0af0f3fc9

Telemetry Enabled:
True

DPI Scale:
150%

Supported Services:
Power BI

[v-cgao-msft]

Hi @KS_B ,

1. Try updating your system & installing the latest Powerbi Desktop.
Download Power BI Desktop from Official Microsoft Download Center

2. Clear Cache: Your PowerBI desktop might have more cache memory. You can clear the cache and then try again.

3. Remove Unnecessary Columns: Try to remove any unnecessary column in Edit Queries before importing in the data model.

4. Allocate More Memory: Try to allocate more memory in the Data Load tab. From Power BI dashboard, open Option > Data Load. Now increase the maximum allowed memory.

5. Increase Computer Memory: One of the ways to fix memory allocation failure error in Power BI is to increase the memory capacity of the computer. You can do this by adding more RAM to your computer or upgrading to a computer with a higher memory capacity. Also, you can fix this error by closing other applications and processes to free up memory for Power BI.

6. Optimize Your Data Model: If your data model is too complex or contains unnecessary data, it can put a strain on your system resources and cause the application to crash². To optimize your data model, start by removing any unnecessary columns or tables. You can also try splitting large tables into smaller ones or using filters to limit the amount of data that is loaded into memory.

7. Use a 64-bit version of Power BI: If you are using a 32-bit version of Power BI, you may want to switch to the 64-bit version which can access more memory.
Please feel free to contact me if the problem remains unresolved.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[foodd]

What is your question? What have you tried and where are you stuck?

[KS_B]

Power BI desktop stops to work while refreshing the data in power query mode. Received 'not enough resources, out of memory' message! How do I fix this issue. I work on a remote desktop. Thank you. 

[foodd]

• Restart the remote machine. 
• Close any applications that are set to autorun. 
• Ensure Power BI Desktop is the current version
• Open an IT Ticket relating this issue so that one of the Desktop Support 
  Folks is able to assist you