Time Exporting with Date

Hello MStark ,

As there is only time in that column it will add a generic date as prefix to make it as required, combine both date and time columns in Power BI then export it into excel which will give proper format. 

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

Thanks your solution Kishore_KVN 

Hi, MStark 

Pls is your current problem solved?

After my testing, if you click on the 3 dots in the upper right corner of the visual and select export data, there will indeed be a date prefix, as shown in the image below:

If you want to keep the format of the time, you can right-click in the table view and select the copy table function:

Go to Excel and paste it:

If your columns are not in the same table, you can create a calculated table, use the Summarize function or Addcolumn function to summarize the columns to be copied in a table, and then use the copy table function.

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.