Forum Discussion
Datamart refresh 'suddenly' broken
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
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