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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Translated caption that only differs in casing shows the object name instead

When I have a table or column with a translated caption, if they only differ in casing, the object name is displayed instead of the translated caption.

 

For example:

Object Name: book

Translated Caption: Book

Displayed Text: book

 

Object Name: bOOk

Translated Caption: book

Displayed Text: bOOk

 

This happens in both Power BI Desktop and Power BI Services.

 

Should be Book and Name, in capital lettersShould be Book and Name, in capital letters

 Since the captions are different than the object names, they are displayed correctlySince the captions are different than the object names, they are displayed correctly

Repro database:

{
  "create": {
    "database": {
      "name": "DB",
      "compatibilityLevel": 1200,
      "model": {
        "culture": "en-US",
        "dataSources": [
          {
            "name": "dataSource",
            "connectionString": "...",
            "impersonationMode": "impersonateServiceAccount",
            "annotations": [
              {
                "name": "ConnectionEditUISource",
                "value": "SqlServer"
              }
            ]
          }
        ],
        "tables": [
          {
            "name": "book",
            "columns": [
              {
                "name": "name",
                "dataType": "string",
                "sourceColumn": "name"
              }
            ],
            "partitions": [
              {
                "name": "book",
                "source": {
                  "query": "select * from rmDMbook",
                  "dataSource": "dataSource"
                }
              }
            ]
          }
        ],
        "cultures": [
          {
            "name": "pt-BR",
            "translations": {
              "model": {
                "name": "Model",
                "tables": [
                  {
                    "name": "book",
                    "translatedCaption": "Livro",
                    "columns": [
                      {
                        "name": "name",
                        "translatedCaption": "Nome"
                      }
                    ]
                  }
                ]
              }
            }
          },
          {
            "name": "en-US",
            "translations": {
              "model": {
                "name": "Model",
                "tables": [
                  {
                    "name": "book",
                    "translatedCaption": "Book",
                    "columns": [
                      {
                        "name": "name",
                        "translatedCaption": "Name"
                      }
                    ]
                  }
                ]
              }
            }
          }
        ]
      }
    }
  }
}

 

 

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @marciorinaldi,

 

From your description, the report gets data from a .json file which which contains value with "Repro database:" you mentioned, right? Wheat you mean about "translated caption"? Would you please share .pnix file with us? 

 

Best Regards,

Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
marciorinaldi
New Member

No, the report gets data from Analysis Services.

The repro database is a Analysis Services script to create a minumum schema to show the issue.

The translated caption is the caption translated using the the Analysis Services' translations schema.