how to change the locale language in a (pyspark) notebook?

[Jerome22]

Hi,

how can we change the locale language in a notebook, the setlocale function is not working and raising a language unsupported error (no matter the language).

Thanks.

[v-nikhilan-msft]

Hi @Jerome22 
Thanks for using Fabric Community.
Currently using locale.setlocale() to change the language of notebook is not supported. But you can change the language for Power BI totally.

Hope this helps. Please let me know if you have any further questions.

[Jerome22 · Accepted solution]

the point is to use localized texts in a notebook.

to format date and currencies (etc) in a specific language.

for example, I want to create a calendar table with english and french columns; so the month name will be in english and another column in french.

I can do it using dataflows, but I also test notebooks and see what I can do with them.

it's a limitation without an impact for me for now, but this should be supported by fabric

[v-nikhilan-msft]

Hi @Jerome22 
Currently only three locale settings are supported in Fabric Notebooks:
C
POSIX
en_US.UTF-8

Hope this helps. 

[v-nikhilan-msft]

Thanks for the feedback @Jerome22 

Appreciate if you could share the feedback on our feedback channel, which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Feedback Link:  https://ideas.fabric.microsoft.com/

Hope this helps. Please let me know if you have any other questions.