Forum Discussion
Solved
Date is not recognized
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 ,...
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
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
v-qiuyu-msft thanks , it works well . that's why i love Power BI Community ^^