topic Setting Regional Formatting for Databricks Connectors in Developer

Setting Regional Formatting for Databricks Connectors

loujiang — Fri, 14 Jun 2024 12:14:31 GMT

Hello, Dear Community,

We are getting data from Connector Azure Databricks. The Azure Databricks will get the Number only based on the Windows Regional Format setting, regardless of which I set in Power BI.

For Example:

I set my Power BI Regional Formatting to English(United States) both for the current file and globally and set the Windows Regional Format to German; however, I still get the decimal Numbers separated with "," like 1,3.

I must change the Windows settings to get 1.3 correctly read from Azure Databricks.

Would someone know how to set the Format correctly for the Power BI so the Azure Databricks connector will get the desired format?

Thanks!

Best wishes

loujiang

Re: Setting Regional Formatting for Databricks Connectors

Anonymous — Mon, 17 Jun 2024 01:21:00 GMT

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

Re: Setting Regional Formatting for Databricks Connectors

loujiang — Mon, 17 Jun 2024 06:44:16 GMT

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

Re: Setting Regional Formatting for Databricks Connectors

Anonymous — Tue, 18 Jun 2024 06:41:41 GMT

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