Relationships view showing local date instad of en-US

[jaryszek]

Hi Guys,

in relationships view I have:

and in power query i have:

= Table.TransformColumnTypes(Source,{{"Month", type date}, {"ResourceId", type text}, {"Cost", type number}}, "en-US")

so as you can see i converted column data types to en-US. 

Why i see in relationships view still polish ones? If this is working properly?

Best,
Jacek

[v-pnaroju-msft]

Thankyou, @daircom, for your response.

Hi @jaryszek,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, Power BI differentiates between Data Type, which is managed in Power Query (impacting storage and calculations), and Data Format (Display Locale), which is managed in Model View (affecting the visual and textual display in reports and relationship views).

When you change the locale in Power Query (for example, to "en-US"), it influences parsing and type conversion. However, the display format in the report or model view follows the system or model culture settings, and not the Power Query locale.

The data type is correctly set by your Power Query step. Nevertheless, the display format in Power BI's model and relationship views must be configured manually in the Model View.
Optionally, you may set the model’s default locale to en-US by navigating to:
File > Options and Settings > Options > Regional Settings.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other members of the community facing similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.

[daircom]

Hi @jaryszek ,

I think the actual data type is correct, but the data formatting is not --> I think what you did was correct: the actual data type is US locale (as your formula is applied correctly). But I think the data formatting which you assign at the front-end was not automatically overwritten. So just go to the modelling view and adjust the format (see highlighted in blue).

Thus: the data type is correct, the data formatting not.

[jaryszek]

Thank you, so this is a good habit to change also data formatting front-end for each column together with power query? Like manually adjust table after importing? 

[daircom · Accepted solution]

@jaryszek ,
Exactly this is a good habit. HOWEVER, you only have to do this for the columns which are actually used in the visuals of the reports (otherwise this can become very time consuming).