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
I have a table in Power BI with blanks and also Text in the following format "01/11/2021 00:00:00"
When I highlight this date column and attempt to convert to data type to date I get an error. "we cannot automatically convert the column to date type".
I'm not sure what's causing it to error. I have other columns that are formatted the same and they converted no problem.
Thanks
Solved! Go to Solution.
HI @obriaincian ,
Pls refer the below:
similar error:
Click transform data:
Adjust to date/time:
Apply and close:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
HI @obriaincian ,
Pls refer the below:
similar error:
Click transform data:
Adjust to date/time:
Apply and close:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
@obriaincian - In Power Query editor, try splitting the column by space delimiter and then convert the Date column to Date Type
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |