Forum Discussion
manah77g
2 years agoRegular Visitor
Date column issue
Hello experts, I imported data from the database. there is a column date which is the completion time, the data type is Date/Time in the power query. when importing data to Power BI, the colu...
Thejeswar
2 years agoSuper User
Hi manah77g ,
As told by AmiraBedh , this also could be the result of a relationship being built on top of this column
If that is not working, then something is not right with your date column. Usually when a Column with Datetime is marked as Date/Time it gets transformed to Datetime format. And a column with AM/PM info in it will usually be a Text Column. See screenshot below
In your case, I am not seeing the data getting converted to datetime values
Regards,
manah77g
2 years agoRegular Visitor
Hello sir
its shows date /time
see the attached in power query