InvalidModelLocaleChangeException error when loading data into datamart

[robshpratt]

Hi,

I can't seem to find anything about this error. Anyone have any ideas what it means? I undid all of my transformations and it still won't load:

[Anonymous · Accepted solution]

Hi @robshpratt ,

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi all,

The team provides a new workaround. It is now possible to quickly transfer the contents of an old datamart to a new datamart: copy and paste the old data into the new datamart.

Something to consider:

• The target datamart should not have any table to be able to change the locale.
• The customer should remember to change the locale before saving the data.
• Please log in to any required credential asked.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi all,

The issue has been referred to other teams for investigation. The team is still working on the fix, I will update here with any new developments or workaround, so please be patient.

Best Regards,

Ada Wang

[Tim_SWRB]

Same issue with Datamart in New Zealand, change locale to US and is now working. Any updates on fixing this?

[v-xiaoyan-msft]

Hi @robshpratt ,

In order to help users who have had other experiences with this issue, we've temporarily marked a user's response as a workaround.
The PG team is working on a fix for this issue, with no definitive ETA at this time, but the community engineers will keep you posted here as progress is made.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous · Accepted solution]

Hi @robshpratt ,

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GuilhermeF]

Hi, any update about the case?

[JK800]

If there an ETA on the fix for this? I just experienced the same bug, for completely inexplicable reasons. I will have to add it to the thousands of productivity hours I have wasted with power bi.

[JPowerBi]

Hi, exact same problem here. I have checked and treble-checked the data sets I'm importing and they all match perfectly, aside of course from the variable value items. I was able to add 2 in one batch earlier today but can now only add a single set. 

[WNCPBI]

I've just had this issue too after taking the following steps:

1. Create a new Data Mart in a PPU Workspace
2. Upload an Excel Workbook into Dataflow
3. Save and return to Datamart, table created as expected
4. Edit a table
5. Create a new table by referencing an existing table, renaming and adding steps
6. Save & Close the DF
7. Get the following error:
   1. Status code: 500 Error Code: InvalidModelLocaleChangeException
8. The new table is not created and the new reference / steps taken in the DF are deleted

[RichardLowery]

I'm also experiencing this issue and it only happens when trying to add additional data or edit data within an existing Datamart.  On this occasion I had 1 table already created, that saved ok, the 2nd table returns the following error:

Loading data

InvalidModelLocaleChangeExceptionErrorMessage

Unable to change Model locale after other objects have been created.

HttpStatusCode400

Activity ID586d0ee9-c0e5-ae8a-b87e-341c7bd35b31

Request ID3b4e5410-4f0d-48a1-967c-cae0cf27c173

Status code500

Error CodeInvalidModelLocaleChangeException

Batch ID67941dd1-1cd2-48f7-8450-945fe497c9b5@5d800a48-00a7-4868-bd44-069a998beebf$2024-02-13T08:34:53.9778071Z@0fd34d51-c438-47ef-870b-7943fd8d2399

[Anonymous]

Hi @robshpratt ,

We are sorry to hear that you are experiencing issues with Datamart. Can you provide some information so we can confirm if this is a known issue. Under what circumstances are you experiencing this issue, when trying to save changes to the Datamart after the initial creation, or is it on the first creation. Do you get an error message when trying to save changes to a newly created Datamart.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fabiel-Valardao]

Ao criar e salvar pode atualizar inúmeras vezes que não gera erro, mas ao realizar qualquer alteração, mesmo de formatação de colunas ao atualizar o erro é gerado. Fiz várias simulações e só ocorre ao alterar as bases.

• InvalidModelLocaleChangeException

  • ErrorMessageUnable to change Model locale after other objects have been created.
  • HttpStatusCode400

[Fabiel-Valardao]

Tenho o mesmo problema e só ocorre ao realizar qualquer alteração nas bases. Fiz vários testes, exclusões e criação de novos fluxos. Posso atualizar várias vezes sem realizar alteração nas bases, mas após a primeira o erro ocorre. 

• Carregando os dados

  InvalidModelLocaleChangeException

  • ErrorMessageUnable to change Model locale after other objects have been created.
  • HttpStatusCode400
    • ID da atividade139cb967-9ed0-0e2e-9a4b-9a582ce2da59
    • Solicitar ID3d63adb0-95c8-4a03-b5dd-636decac7925
    • Código de status500
    • Código de ErroInvalidModelLocaleChangeException
    • ID do Lotecaffbced-3dc2-4604-9c24-baa1064513e5@7edd1e30-2c8a-41d5-a8d5-13b46e7cae7b$2024-02-15T14:50:31.4797147Z@a6797014-b7a8-4c6d-a714-5fc87023b146CopyGet Help

[robshpratt · Accepted solution]

Hi,

This issue occurs when editing and then loading a datamart for the second time after creation. Everything works ok on the first load.

I found a workaround on another thread to change the local to US from UK which is not ideal but its working for now.

Regards

Rob

[WNCPBI]

Thanks for that. That workaround worked for me too. My DM-DataFlow locale was English United Kingdom, switching to US fixed the error.

[Fabiel-Valardao]

Can you help me, how can I change this setting?

[WNCPBI]

In the dataflow click "options" and change to US:

[Fabiel-Valardao]

Perfect, it worked. Thank you very munch!

[Ephix]

 

[Fabiel-Valardao]

Thank you vey munch!