Enterprise gateway scheduled refresh error (OutOfMemoryException)

[Anonymous]

Hi, When I refresh my dataset manually it goes without problems, the problem occurs on a scheduled refresh. Here's the error messages from the server's errors log in order. (the refresh is scheduled at 5 AM)

At 5:09:23 

Spoiler

Application: Microsoft.PowerBI.EnterpriseGateway.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.OutOfMemoryException at Microsoft.Mashup.Evaluator.SafeThread2+DefaultExceptionHandler.TryHandleException(System.Exception) at Microsoft.Mashup.Evaluator.SafeThread2.HandleException(System.Exception) at Microsoft.Mashup.Evaluator.SafeThread2+<>c__DisplayClass15.<CreateAction>b__14(System.Object) at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) at System.Threading.ThreadHelper.ThreadStart(System.Object)

At 5:09:23

Spoiler

Faulting application name: Microsoft.PowerBI.EnterpriseGateway.exe, version: 3000.0.265.0, time stamp: 0xdf342274
Faulting module name: KERNELBASE.dll, version: 6.3.9600.18938, time stamp: 0x5a7ddf0a
Exception code: 0xe0434352
Fault offset: 0x0000000000008eac
Faulting process id: 0x2ba4
Faulting application start time: 0x01d4c2b8e45fb6ba
Faulting application path: C:\Program Files\On-premises data gateway\Microsoft.PowerBI.EnterpriseGateway.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: c2e0cd33-2f3c-11e9-80cf-0050568116db
Faulting package full name:
Faulting package-relative application ID:

 At 5:09:46

Spoiler

The Open Procedure for service "Lsa" in DLL "C:\Windows\System32\Secur32.dll" failed. Performance data for this service will not be available. The first four bytes (DWORD) of the Data section contains the error code.

At 5:09:46

Spoiler

The Open Procedure for service "WmiApRpl" in DLL "C:\Windows\system32\wbem\wmiaprpl.dll" failed. Performance data for this service will not be available. The first four bytes (DWORD) of the Data section contains the error code.

thanks in advance

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Do you have a pro account?

if so, you could create a support ticket(free for pro users) for more quick help.

https://powerbi.microsoft.com/en-us/support/

There may be some changes which doesn't support in power bi or in specific datasource.

For example:

If your datasource is a SQL query->

When you transform a column to number, if this is a text field It does not allow this transform folded since SQL query does not handle this directly.

This is the possible reason for the folding failure.

you should rework the query to not convert a text fields to numbers.

Best Regards

Maggie