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

[mark-alford]

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/

[bapt69]

My datasource => Dataverse (Common Data Service connector)

The new datamart has the same problem too

[mark-alford]

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]

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

[v-yetao1-msft]

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]

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]

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]

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]

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]

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]

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