Date column not recognized as Date in Data View despite setting UK locale

[Rufyda]

I have a dataset from a UK bank that includes a date column. I tried setting the timezone/locale to the United Kingdom, but the column is still not recognized as a Date. As a result, in the Data View, the column does not appear as a date type, and I cannot perform date-based operations on it.

Dataset source: UK bank

Column format: Standard date strings (e.g., DD/MM/YYYY)

Action attempted: Set timezone/locale to UK

Issue: Column still not recognized as Date

Could you advise how to make the system recognize this column as a Date?

Thank you!

[ANVS]

Hi @Rufyda 

Thanks for reaching out to the Fabric Community for help.

U can solve this issue by chaning the Data type by going to power Query from Power BI Desktop and select the Date Column and choose the Data Type as Just "Date". And also you can try enabling the Auto/Date Time Feature in Power Bi Desktop by going to the Options and Settings In Power BI Desktop.

[v-pgoloju]

Hi @Rufyda,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @danextian and @anilelmastasi  for prompt and helpful responses.

Try as a work around by unabling the auto date time feature in current file (or) If Power BI doesn’t recognize your UK style date (DD/MM/YYYY), open Power Query and right-click the date column then choose Change Type to Using Locale, then set the type to Date and locale to English (United Kingdom). If that still doesn’t work, create a new column using a formula like Date.FromText([Date Joined], "en-GB") to force it into a proper date format. After applying and loading the data, check the Model or Data View to make sure the column’s data type is set to Date.

Thanks & Regards,

Prasanna Kumar

[Rufyda]

https://drive.google.com/file/d/1tpA-rpYR57owlpr3sapnSna979hoxGXx/view?usp=sharing 

[danextian]

Hi @Rufyda 

It already shows as date type in Power Query. If the date column is on the many side of and is being used in a relationship, it won't show a date icon before it but the data type should show as date.

[Rufyda]

I have one Table 
no relationship!

it appears in power query as data but text in data visu 

[danextian]

It already is a date as per your pbix. 

If you're looking for the calendar icon before the column name, that shows up only if auto date hierarchy is enabled which automatically adds a date hierarchy to most date columns. 

[anilelmastasi]

Hello @Rufyda ,

I could not understand. It shows date type in power query. Can you explain it more please?

[anilelmastasi]

If I have to guess, in Table View select the Date Joined column and in Data Type section select Date too.