Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to 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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |