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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

The Datamart is not finalized in a failed state

Hi,
I've been trying datamarts and sundenly stops working. Error message:

 

We couldn't retry your suspended datamart

The datamart '7311451b-1916-4f3b-850d-ebbf544d5462@a4033506-68f5-4133-8ad9-b7c8daeafb75' is not finalized in a failed state, hence a manual resume opertion is not possible.

Please try again later or contact support. Please provide these details if you contact them.

Identificador de actividad: b9b504d5-114a-463f-bb8a-9acecc318de4
Identificador de la solicitud: 06e70846-682d-4854-a633-1ec19712cfa2
Id. de correlación: 60b4aa09-a11f-7f53-09e4-513f376aad26
Código de estado: 400
Hora: Fri Aug 19 2022 09:09:26 GMT+0200 (hora de verano de Europa central)
Versión del servicio: 13.0.18848.49
Versión del cliente: 2208.2.12691-train
URI de clúster: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/

Status: Investigating

Hi @Anonymous

Is this your first time creating a datamart ? Has it worked successfully before ? If yes , have you made any updates to the datamart ? What is the data source of your datamart ?

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @Anonymous

Is this your first time creating a datamart ? Has it worked successfully before ? If yes , have you made any updates to the datamart ? What is the data source of your datamart ?

 

Best Regards,
Community Support Team _ Ailsa Tao

seba8282
Employee

Having the same issue, sometimes it resets itself, sometimes I have to recreate it. Is there a fix coming?

Anonymous
Not applicable

Same here, I made a datamart which currently has about 20 tables and 8 functions and the more I add, the more often it seems to happen. Everything in it loaded fine while editing in power query, after attempting to save my changes the Save process failed on last step (something like Finishing...).

Anonymous
Not applicable

Btw just found out - if you restart your workstation, the error goes away and Power BI offers to continue editing where you left off. So I believe this could be browser cache issue.

Anonymous
Not applicable

Same here, I lost all access to the datamart and yesterday I tried to backup it but didn't find a way like export json like dataflows have. So lost all transformations and would have to build from scratch.

 

We couldn't retry your suspended datamart

The datamart 'd6b16f2b-89b6-4ba1-915a-d0d5853f6e03@38c1b8d0-0b92-4243-bdc8-996954eb9863' is not finalized in a failed state, hence a manual resume opertion is not possible.
Please try again later or contact support. If you contact support, please provide these details.

Activity ID2e249ac1-65a8-4e55-b6c5-3a8f4c09cce4
Request ID13b03...194
Correlation ID1e1b60c...1ace
Status code 400
Time Fri Oct 21 2022 10:45:42 GMT-0300 (Horário Padrão de Brasília)
Service version13.0.19270.46
Client version2210.2.13483-train
Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net/

josecgomez
Frequent Visitor

Any updates on this? I am having the same problem

heba__abdelshaf
Regular Visitor

@seba8282 @v-yetao1-msft 

Have the same error here, kindly I need your support as I can't recreate it from scratch

 

We couldn't retry your suspended

The datamart '235c212c-c565-4dfe-9971-fcb7f20443e9@42ccb62d-f357-46a8-bf7a-29de1fa3e950' is not finalized in a failed state, hence a manual resume opertion is not possible.

 

Activity ID: 75de08b1-8d77-4663-8ab9-60b1fdd2b579
Request ID: acaa4903-084e-4f10-b4ac-aeff7de97f51
Correlation ID: 4e9eeee8-5948-72f2-5e0b-b116610b4be3
Status code: 400
Time: Thu Feb 09 2023 18:02:19 GMT+0200 (Eastern European Standard Time)
Service version: 13.0.20006.56
Client version: 2301.5.12183-train
Cluster URI:

bi_SPMS
New Member

Same here, I lost all access to the datamart.

 

We couldn't retry your suspended

The datamart '17278225-d44c-4380-bbba-5c7b8c06e87b@c85f54a6-ef27-45f0-a09b-ad7a6227f459' is not finalized in a failed state, hence a manual resume opertion is not possible.

Tente novamente mais tarde ou entre em contacto com o suporte. Se contactar o suporte, forneça estes detalhes.Ocultar detalhes
  • ID de atividade16f00f37-861e-4559-8713-b230b5b43afb
  • ID do Pedido7eeff1cf-6b64-495e-b466-9c05e9a0250a
  • ID de correlação472294ba-0124-2ea9-4ae9-99af45fe67ac
  • Código de estado400
  • HoraTue Feb 28 2023 09:51:25 GMT+0000 (Hora padrão da Europa Ocidental)
  • Versão do serviço13.0.20105.47
  • Versão Cliente2302.2.12402-train
  • URI de Clusterhttps://wabi-north-europe-redirect.analysis.windows.net/
bartvanbenthem
Regular Visitor

For me the same. This is the second time it happens ..... Am waiting already 24 hours for it to work again...

Please help me, because a lot of work is in it....!

We couldn't retry your suspended

The datamart '76d7a296-77dd-4b2a-a6b4-c0b0a2dc1065@80c72bc5-b6db-4037-8317-fae08b92bce0' is not finalized in a failed state, hence a manual resume opertion is not possible.

 

Activity ID: a2a9222f-1ab7-4567-9c6d-ee6830de4365
Request ID: 9abfb923-c9a2-44c8-b9b3-a52c59561403
Correlation ID: 7b65bee1-0c6b-25b8-3120-8ea3e0e6bce2
Status code: 400
Time: Tue Mar 07 2023 20:13:16 GMT+0100 (Midden-Europese standaardtijd)
Service version: 13.0.20195.63
Client version: 2302.4.12605-train
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/

smpa01
Super User

I have the same issue. This datamart had masive downstream dependencies, thaey are all gone now. please help.

smpa01_0-1678717074304.png

 

The above triggers this

 

Capture.PNG