Date Conversion Error Power BI/Query

[Khomotjo]

Hello Everyone,

Anyone has any idea why a date coloumn loads as text in power BI. I have  tried to :

1. Split the coloumn and create the date field using the power query #date 

2.I have tried to change the date coloumn > Uning locale> selected date. selected South Africa

Still no success

[ryan_mayu]

@Khomotjo 

if your column has the same data format. Then you can try to ceate a column from example. You just need to type in the first or first several expected output. Then it will convert the rest for you.

https://learn.microsoft.com/en-us/power-query/column-from-example?wt.mc_id=DP-MVP-5004616

[Ashish_Mathur]

Hi,

Please share some data to work with.

[Thejeswar]

Hi @Khomotjo ,

I don't think using locale is the best way to define datatype for a column.

Usually, locale is used to show data friendly to a certain locale the reports are being used.

In an ideal case, using #date should create a Date value. If it is not happening, better way to do this would be to change the datatype in Power Query for the column to date

Regards,