Datamart refresh 'suddenly' broken

[JS23]

Hi all,

I have a datamart (and a PBI PPU license) in place with 1 large fact table (31M rows, datasource = Oracle DB On Prem via Gateway) and a few small dim tables sourrounding it (data source = Oracle DB + Excel file on Sharepoint). The initial load was a struggle, but I pulled it of. Once loaded, I set up incremental refresh, only refreshing the last 3 days of date. The scheduled refresh went well, +/- 1min. So far so good.

Yesterday I suddenly got an error message from the refresh.

1) The refresh history gave me the following error message (after having downloaded it in CSV)

Refresh start time	0:00:00
Refresh end time	0:00:00
Refresh Status	Not Found
CPU Usage (milliseconds)	Error: undefinedErrorMessage=Encountered user gateway exception: '<ccon>Evaluation resulted in a stack overflow and cannot continue.</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>Evaluation resulted in a stack overflow and cannot continue.</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [InnerType]=ErrorException <ccon>Evaluation resulted in a stack overflow and cannot continue.</ccon> [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=334108]/MashupDataAccessException[ErrorCode=-2147467259
Table start time	HResult=-2147467259]/Wrapped(MashupException)[ErrorCode=-2147467259
Table End Time	HResult=-2147467259]/Wrapped(ErrorException)[HResult=-2146233088]/Wrapped(ErrorException)[HResult=-2146233088]/Wrapped(ErrorException)[HResult=-2146233088] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=334108]'.HttpStatusCode=0.
Dataflow table name
Partition name
Rows processed
Error

2) When going into the Power Query Editor, not making any changes, and hit save, I get the following error in the loading pop-up screen:

"Data load failed

Power query processing

PQO Evaluation Failed

• Raw_Data_VouchersPowerQuery response to 'https://europe.prod.powerquery.microsoft.com/api/evaluator/evaluate' return with error message 'Container exited unexpectedly with code 0xE0434352. PID: 5908.' and errors: 'Microsoft.PowerBI.Cdsa.Common.ExceptionResultError[]'"

Any idea on why this suddenly happens? Storage/Capacity issue? Or how to fix it? --> Time to migrate to Fabric I suppose? 😉

[v-nmadadi-msft]

Hi @JS23 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @JS23 
Thanks for reaching out to the Microsoft fabric community forum.

Based on the error message the root cause of the error is either of these two cases:

Please check your M query to see if they have, for example, a function which calls itself recursively. In this case the query should be rewritten to iterate using List.Generate instead of recursion in order to avoid this problem.

The gateway machine is not having enough resources to process the queries and for that reason it would be a customer environment problem which should be resolve by adding more resources to the machine.

Most likely the second point is the cause of these kind of errors, additionally as mentioned by @SaiTejaTalasila  and @Deku  datamart will be retired soon.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[SaiTejaTalasila]

Hi @JS23 ,

You need to migrate from power bi datamart to onelake as the feature will be dicomissioned from fabric.

Thanks,

Sai Teja 

[JS23]

I understand that it will disappear, nevertheless I would like to understand the root cause of the issue...

[Deku]

Datamarts are also being depricated in oct-25, would be sensible to migrate ASAP

https://powerbi.microsoft.com/en-us/blog/unify-datamart-with-fabric-data-warehouse/#:~:text=Starting....