Datamart error with status code 500

[rubymaya]

Hello,

Im trying to load data from Blob & G.Sheet into datamart and failed with a 500 error (see below). The error didnt tell which table/query is having problem. Have anyone experienced this before?

Activity ID: 1d6122df-8a8e-1f51-8fc3-31f8f14da2fc
Request ID: d3fcc389-09e6-4196-94de-653dc7bf3dfa
Status code: 500
Error Code: OperationCanceled
Batch ID: 6ef51b3c-c806-40d3-8e29-f9a245d44730@61ab3eab-af28-450e-acbc-7434bea7c47b$2022-12-28T14:07:07.277619...

[Anonymous]

Hi @rubymaya ,

During our investigating we found that there have been users in the past who had similar experiences to you, you can check this thread to see if it helps.

Solved: Datamart operation canceled - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn

[rubymaya]

Thanks,

Again today, i received another error, and it doesnot pinpoint where the problem is. The operation just got stuck before loading data. There was no problem when editing, i did refresh every single query without problem. I cannot save my whole day work now. Im depending on the datamart cache to detect this "CONTINUE WITH WHERE YOU LEFT?" to keep my changes 😞

See the error, which is not helping

[TheDaniel007]

Hi I am having the same problem. data loads perfectly but its gives me an error 500