How to overcome language barrier in Dataverse?

Question

this wont work if the dataverse tables have been created with Dutch default language.

We get this error:

{   "error": {     "code": "0x80048d0b",     "message": "{"operationStatus":"Error","error":{"type":"Error","code":"KnowledgeGroundingApiError","message":"{\"errorCode\":\"UnSupportedLanguageException\",\"errorMessage\":\"Language with id 1043 is not supported.\"}","properties":{"KnowledgePrompt":"SCRUBBED","KnowledgeApiStatusCode":"BadRequest"}},"predictionId":null}"   } }

This question is related to the following Learning Module

Answer 1

The error you're seeing (UnSupportedLanguageException with language ID 1043) indicates that Dataverse tables created with Dutch as the default language aren't supported for this operation. The language ID 1043 corresponds to Dutch (Netherlands).

Here’s how you can address this:

1. Set a Supported Language (e.g., English - 1033)

If possible, update the default language of your Dataverse environment to English (ID: 1033). This ensures compatibility with the API you're calling.

1. Go to Power Platform Admin Center.
2. Select the environment with the Dataverse tables.
3. Under Settings > Languages, add or change the default to English (1033).
4. Duplicate Tables in English

• Create a duplicate of the problematic tables but set the base language to English during creation.
• Migrate data from the Dutch tables to the new ones using Power Automate or Dataflows.

3. Force Language Override (If Supported by API)

Some APIs allow specifying the language in the request body or header. Try explicitly setting the language to English like this:

{
  "language": "en"
}

If no such parameter exists, this method won’t apply.

4. Translate Table Fields

If the issue is related to specific fields, use Power Automate or custom code to translate the Dutch field names to English.

---

If changing the language isn’t feasible for the entire environment, consider raising a support ticket with Microsoft to inquire about Dutch language support timelines. The error you're seeing (UnSupportedLanguageException with language ID 1043) indicates that Dataverse tables created with Dutch as the default language aren't supported for this operation. The language ID 1043 corresponds to Dutch (Netherlands).

Here’s how you can address this:

1. Set a Supported Language (e.g., English - 1033)

If possible, update the default language of your Dataverse environment to English (ID: 1033). This ensures compatibility with the API you're calling.

1. Go to Power Platform Admin Center.
2. Select the environment with the Dataverse tables.
3. Under Settings > Languages, add or change the default to English (1033).
4. Duplicate Tables in English

• Create a duplicate of the problematic tables but set the base language to English during creation.
• Migrate data from the Dutch tables to the new ones using Power Automate or Dataflows.

3. Force Language Override (If Supported by API)

Some APIs allow specifying the language in the request body or header. Try explicitly setting the language to English like this:

{
  "language": "en"
}

If no such parameter exists, this method won’t apply.

4. Translate Table Fields

If the issue is related to specific fields, use Power Automate or custom code to translate the Dutch field names to English.

---

If changing the language isn’t feasible for the entire environment, consider raising a support ticket with Microsoft to inquire about Dutch language support timelines.