Date format is incorrect for region

[coolie]

All date formats in Fabric are US. I have language set to English UK in Windows and Chrome, and Power BI is set to use browser language. How do I get the date to display in sensible format dd/mm/yyyy in lakehouse, pipelines etc?

[v-ssriganesh]

Hi @coolie,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @coolie,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @coolie,
Thank you bringing your query to the Microsoft Fabric Community.

Also, a big thank you to @nilendraFabric for sharing helpful insights on working with date formats in Pipelines and Power Query. Those suggestions are indeed correct and valuable.

Let me expand a bit to clarify how date formats behave across different Fabric components:

• As mentioned, in Data Pipelines, you can use the formatDateTime() function to explicitly format dates as per your regional preference (e.g., dd/MM/yyyy)
  🔗 Reference – Pipeline Expression Functions
• When working in Power Query (e.g., Dataflows or Data Wrangling in Lakehouse), you can set your preferred locale to ensure dates are interpreted and displayed correctly. Select the Date/Time column. Go to Transform → Data Type → Using Locale. Select Date and choose English (United Kingdom) (or your preferred region).
• If your concern is specifically about the date format in the Lakehouse data preview UI, please note that currently, the Lakehouse UI preview displays dates in US format (mm/dd/yyyy) by default. This display setting cannot be customized based on your browser, Windows, or Power BI locale settings. However, the underlying data is stored correctly, and this display format does not affect your data processing or reporting in Power BI.

We encourage you to share your feedback or suggestions on the Fabric Ideas Forum to help prioritize enhancements in this area.

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily. 
Thank you.

[v-ssriganesh]

Hi @coolie,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[nilendraFabric]

Hello @coolie 

not sure if I understood the question properly 

but try Use the `formatDateTime()` function to explicitly format dates into DD/MM/YYYY format in pipeline 

or you can change Using Locale Settings in Power Query

@formatDateTime('2025-02-13T18:33:00', 'dd/MM/yyyy')