Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Datamart is in a critical state

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:

ericmarshall_0-1708491997912.pngericmarshall_1-1708492062062.png

 

ericmarshall_2-1708492093674.png


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

Status: Needs Info

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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
Regular Visitor

@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.

ericmarshall_0-1708519976019.png

ericmarshall_1-1708520139185.png

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

 

 

ericmarshall
Regular Visitor

ericmarshall_0-1708555547626.png

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

@v-yetao1-msft 

 

ericmarshall
Regular Visitor

@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.