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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

BUG: We couldn't get your datamart's updated schema

Unable to refresh data in the datamart, following error.

 

We couldn't get your datamart's updated schema

The datamart data is invalid


Activity ID: f817febf-3293-4b66-a64d-0ac1c9987419
Request ID: b247eba4-d0b6-440d-8000-e8d6fe3d6459
Correlation ID: 0fefd113-83ba-4f76-c8d0-6d4464a511b2
Status code: 400
Time: Mon May 22 2023 23:16:52 GMT+0100 (British Summer Time)
Service version: 13.0.20726.71
Client version: 2305.3.13975-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

Status: Accepted

Hi @mark-alford 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress. 

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
bapt69
Helper I

My datasource => Dataverse (Common Data Service connector)

The new datamart has the same problem too

mark-alford
Regular Visitor

I've simply moved to using dataflows, hopefully when this product works and is stable (experience other issues such as errors when saving datamart etc) we can use it again.

Quite easy to migrate flows by selecting the entity -> advanced editor, and copy/pasting all the steps.

Momme
Advocate I

@mark-alford I did the same, but direct-query / filtering with fieldparameters is considerably slower than with SQL datamarts.

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

HI @mark-alford 

We have also received feedback from other users and have a question to confirm with you again . Have you ever encountered a situation where the refresh option exists sporadically ?

 

Best Regards,
Community Support Team _ Ailsa Tao

mark-alford
Regular Visitor
We have also received feedback from other users and have a question to confirm with you again . Have you ever encountered a situation where the refresh option exists sporadically ?

No, not that i've noticed.

Anonymous
Not applicable

Same problem here... wanted to migrate all dataflows to datamarts in order to have RLS and better manage accesses, but now we stopped that idea.

I also noticed that roughly 1-2 weeks ago the access was suddenly only possible when access to whole workspace was given (so for my use-case, main reason for migration from dataflow to datamart was lost). Now the refresh is also failing...

FernandoJRJ
Regular Visitor

Same here.

 

We couldn't get your datamart's updated schema

The datamart data is invalid

Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes.Ocultar detalhes
  • ID da atividadefde116fe-0eb5-4f11-8b0b-f8731a87ef62
  • Solicitar ID77189a25-1b3a-4d04-b065-db06fb7a98ac
  • ID de correlaçãof64fc303-82e1-c4b4-d846-734ab1b97ca5
  • Código de status400
  • HoraTue Jun 13 2023 10:37:25 GMT-0300 (Horário Padrão de Brasília)
  • Versão do serviço13.0.20866.74
  • Versão do Cliente2306.1.14294-train
  • Cluster URIhttps://wabi-brazil-south-redirect.analysis.windows.net/
v-yetao1-msft
Community Support
Status changed to: Accepted

Hi @mark-alford 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress. 

 

Best Regards,
Community Support Team _ Ailsa Tao

sams99
Regular Visitor

Would this bug impact the ability for users to access report data built on top of the datamart/dataset(default)?

Because once you give permissions to the datamart it can't sync?

 

Is there an ETA?

dheerajp
Regular Visitor

@v-yetao1-msft we are facing the same issue with the datamart. Is there an Issue log where we can track the status of this being resolved?