why do i get timetamp on date columns in power BI

[Anonymous]

I have a  power BI dataset that shows  time stamps in every date column even though same date columns dont have a time stamp in the source data (oracle database) I have tried to remove the  time stamp   but  when i bring the dataset to report builder it still shows time stamp and  i cant get how to remove timestamp on adate column in report builder and use that column as a parameter. Anyone else faced this chanllenge?

[v-yalanwu-msft]

Hi, @Anonymous ;

Sometimes the date column will be in Date/Time format, there are two ways to change it:
1. When all are displayed as date 12:00:00，we could change the type to Date rather than Date/Time.

2.if not 12:00:00 AM like Date column. we could add new column to change Date.

=Date.From([Date])

The final show：

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("LcqxCQAxDAPAVYLrCCSZpPAqwfuvEch/e9w5YdoQ4RxyMYsr5q/Cjp7vCIY5pCKL+yvCQkb3BQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, date2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetime}, {"date2", type date}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "New", each Date.From([Date]))
in
    #"Added Custom"

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

unfortunately since i am using direct query, non of this suggestions are working. i get this error message . any suggestions on the workaround?