Column Data type set as Time but export of data shows data and time

[jbrines]

Hi Guys,

In a query I have formated a column with a data type of Time but when I export the table it is showing the column as the following, how do I get the export file just to show the time? 

1899-12-30 14:11:09

On the query

On the Report

[v-csrikanth]

Hi @jbrines 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @jbrines 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @jbrines 
Sorry for the late response.
As highlighted by @Deku @shafiz_p  , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.

[shafiz_p · Accepted solution]

Hi @jbrines  If you're exporting to Excel, you can format the column to show only the time in excel. Also, You can try create a calculated column with format function and try using that column in the report:

TimeOnly = FORMAT(your_table[your_column], "HH:mm:ss")

also, you can trying override data type in power bi too.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

BR,

Shahariar Hafiz

[Deku]

Power BI doesn't have a time data type. Dates, times and datetimes are all datetimes times, which is represented as a decimal value. When you export to excel, excel infers the decimal as a datetimes. You can use measures to visualise the dates, with FORMAT( tbl[time], "HH:MM:ss"), to avoid the conversion in excel