Forum Discussion
Datamart refresh 'suddenly' broken
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
- 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? 😉
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
5 Replies
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 youDatamarts are also being depricated in oct-25, would be sensible to migrate ASAP
I understand that it will disappear, nevertheless I would like to understand the root cause of the issue...
Hi JS23 ,
You need to migrate from power bi datamart to onelake as the feature will be dicomissioned from fabric.
Thanks,
Sai Teja
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.
