Power BI Data Culture

[Kealkil42023]

I created a new empty model just to test the settings. 

Culture, which is now visible in Semantic Model, is showing en-US.

But my settings are as follows:

Windows 10 Region is set to Ireland and Regional Format is set to English (Ireland)

Power BI Desktop Options -

    Global Regional Settings:   English (United States) is the only English language appearing in the dropdowns

         Application Languge  .... Use Windows default display language is my selection

         Model Language .... Use application language   is my selection

    Current File Regional Settings:

         Locale for Import .... English (Ireland)

This will ultimately impact on an Excel Connection to a model in the Power BI Service ... where Start / End Dates have to be formatted and presented as MM/DD/YYYY in order to retrieve data.

How do I get the Power BI culture set to a European Format?

ps   To the best of my knowledge there is only one country that uses the MM/DD/YYYY format as a standard.   Why does Power BI default to the minority position???

[jennratten]

Hello @Kealkil42023 - 

• The model's regional settings will either match your Windows setting or a different one manually selected in the drop-down.
• The culture for which the model is applied when consumed by a user is controlled in PowerBI desktop in the Current File Regional Settings and in Excel with it's own regional setting (see steps below).

• If you are not seeing English (Ireland) as an option for you in Windows, you an try to add it:
  • If a user doesn't see the Windows regional option of English (Ireland), they can follow these steps to add it:
  • Open Settings: Press the Windows key + I to open the Settings app.
    Time & Language: Click on "Time & Language" and then select "Region & Language".
    Add a Language: Under the "Languages" section, click on "Add a language".
    Select English (Ireland): Scroll through the list and select "English". Then, choose "English (Ireland)" from the list of English language options.
    Set as Default: Once English (Ireland) is added, click on it and select "Set as default".
    Restart Your Computer: Restart your computer to apply the changes.
    If the option is still not available, it might be due to the version of Windows being used or regional restrictions. In such cases, users can try the following:
  • Control Panel: Open the Control Panel by pressing Windows key + R, typing "control", and pressing Enter. Go to "Clock and Region" > "Region" > "Administrative" tab > "Change system locale" and select "English (Ireland)".
    Update Windows: Ensure that Windows is up to date. Sometimes, regional options are added or updated in newer versions of Windows.
    Language Pack: Download and install the language pack for English (Ireland) from the Microsoft website or through Windows Update.
• To set the regional settings for Power Query in Excel, follow these steps:
  • Open Excel: Launch Excel on your computer.
  • Go to Options: Click on File in the top-left corner, then select Options.
  • Query Options: In the Options window, navigate to Data > Query Options.
  • Regional Settings: Under Current Workbook, select Regional Settings. 
    • https://support.microsoft.com/en-us/office/set-a-locale-or-region-for-data-power-query-d42b9390-1fff... 

• You can also ensure that dates are formatted and presented as DD/MM/YYYY, by using the Format function in Power BI. For example, you can create a new column in your data model with the following DAX expression:

  FormattedDate = FORMAT([YourDateColumn], "dd/mm/yyyy")