Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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
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.
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.
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.
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |