Forum Discussion
Post ProdigyDate 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 , it appeared error . No idea how to fix this.
Anyone can tell me how to settle this ? i also tried Split column.
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
2 Replies
v-qiuyu-msftCommunity Support
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 ^^
