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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
loujiang
Regular Visitor

Setting Regional Formatting for Databricks Connectors

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 

1 ACCEPTED SOLUTION

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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:

loujiang_0-1718606422558.png

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.