Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
At 5:09:46
thanks in advance
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.