When using Analysis Services, you can add a Translations
file to provide locale dependant object names. At present this is working fine.
When I come to view the data however, boolean True
or False
values are always in English.
As you can see from the screenshot below, the Power BI interface and visualisations have picked up the French language setting and applied the appropriate object names, but the True
and False
remain (the exact same is seen when actually downloading the French version of Power BI desktop too):
As a boolean/logical value is simply a bit
value and not a string
of data or potentially ambiguous due to formatting (such as dd/mm/yyyy
and mm/dd/yyyy
dates), I would have thought Vrai
and Faux
would be used as it is when using Excel formulas.
This seems to be purely an issue with how the Vertipaq engine transmits its data. If you add a new Measure to a Power BI dashboard running in the French language that always returns False
, you get the same problem:
and even if you analyse the model within French Excel, you get the same problem:
Has anyone found a way around this that ideally doesn't rely on string representations of the boolean values?