Forum Discussion
Setting Regional Formatting for Databricks Connectors
HI loujiang,
>> However, both did not work. Is there something I missed?
In fact, these should effect the PBI desktop client languages and UI of the chart axis, they not affect the display formats.
If you want to change the symbol and region formats, you may need to change on your system region and symbol settings, power bi default formats are based on these.Decimal separator changes after Update to Windows 11 - Microsoft Community
You can also try to modify the field format string to change the output format without modify the system settings.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi loujiang,
After you getting data to power query side, you can try to use change type with locale option to help recognized and transform field values more accurately.
Change Type Using Locale with Power Query
Use locale values in multiple-language Power BI reports - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hello, Xiaoxin,
Thanks for the reply. The manual setting of the locale would partly solve the issue.
But my main pain point would be the setting here at Power BI would not take effect:
For example, even though I have set the English here, the Power BI Databricks Connector still returns the DE format according to the Windows level setting.
I tried the GLOBAL and CURRENT FILE settings. I restarted Power BI after changing the GLOBAL Setting and applied the changes after changing the CURRENT FILE setting. However, both did not work. Is there something I missed?
Thanks!
best wishes
Loujiang
HI loujiang,
>> However, both did not work. Is there something I missed?
In fact, these should effect the PBI desktop client languages and UI of the chart axis, they not affect the display formats.
If you want to change the symbol and region formats, you may need to change on your system region and symbol settings, power bi default formats are based on these.Decimal separator changes after Update to Windows 11 - Microsoft Community
You can also try to modify the field format string to change the output format without modify the system settings.
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng