Forum Discussion

robshpratt's avatar
robshpratt
Advocate I
2 years ago
Solved

InvalidModelLocaleChangeException error when loading data into datamart

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:

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

  • robshpratt's avatar
    robshpratt
    2 years ago

    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

21 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • JK800's avatar
      JK800
      Frequent Visitor
      2 years ago

      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's avatar
    JPowerBi
    New Member
    2 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • robshpratt's avatar
      robshpratt
      Advocate I
      2 years ago

      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's avatar
        WNCPBI
        Frequent Visitor
        2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, i have the same problem. it's appear after first datamart creation. if you try to edit datamart, after only refresh data or adding new table or column, when you close power query editor the process "Loading data" stopping with this error and there isn't relevant information how to solve it

    • Fabiel-Valardao's avatar
      Fabiel-Valardao
      Regular Visitor
      2 years ago

      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
  • RichardLowery's avatar
    RichardLowery
    Regular Visitor
    2 years ago

    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
  • WNCPBI's avatar
    WNCPBI
    Frequent Visitor
    2 years ago

    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
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

     

  • Tim_SWRB's avatar
    Tim_SWRB
    New Member
    2 years ago

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