Datamart is in a critical state

[ericmarshall]

I have a datamart that normally takes around 30 minutes to refresh. This morning the refresh started taking over an hour and keeps failing.

When I try to open the datamart and load the data, I get the below error messages:

Activity ID: 0cdfe16a-eac9-06f5-1c18-8714ae4eb566
Request ID: a0fdabab-06d0-4ad5-9261-fb003b6d488f
Status code: 500
Error Code: InternalError
Batch ID: c2f0c8f5-1f88-4d2e-9c4c-2e6a56eca1e9@50248689-f38d-4887-92bc-cfce8160e39b$2024-02-21T04:57:52.9094366Z@f44fac28-4bfe-47d8-a4d6-0f30717cde4e

[v-yetao1-msft]

Hi @ericmarshall 

Did you do an update to datamart and what is the corresponding data source for datamart? If you refresh it manually do you still have the same problem? Does your other datamart refresh properly?

Best Regards,
Community Support Team _ Ailsa Tao

[ericmarshall]

@v-yetao1-msft 
I am unable to perform a manual or automated refresh of the datamart now. All data sources for the datamart are dataflows. I don't recall doing an update to the datamart or anything out of the ordinary.

I have tried following the above error message but it doesn't work either.

[ericmarshall]

I am still unable to open the datamart, go to Transform data and click Save.

@v-yetao1-msft 

[ericmarshall]

@v-yetao1-msft would you happen to have an update on this one? The datamart now completely doesn't work at all (all queries appear to have disappeared).

As a workaround I had to copy all of my queries out and create a brand new datamart.