Date is not recognized

[Chanleakna123]

Hi team , 

I have Date and time in excel , after i upload into Bi , Date and time displayed to number instead. While i tried to transform to Date format , I changed at Data Modeling , Quries , it appeared error . No idea how to fix this. 
Anyone can tell me how to settle this ? i also tried Split column. 

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

In your Query Editor, please remove first 4 rows which have null values. Then promote the first row as header via "Use first row as headers" button. Then select the Date/Time Receive column, change Data type as Date. 

If above doesn't work, please share the source file and pbix file with us. 

Best Regards,
Qiuyun Yu

[Chanleakna123]

@v-qiuyu-msft thanks , it works well . that's why i love Power BI Community ^^