CSV Import Issue

[Malsha]

Hi everyone,

when I export my report data to csv, time fields display wrong values. in the csv file, time fields display a date in every row. This is how power bi report shows the time fields.

This is how exported csv file shows the time fields.

I opened this as a text file also. but the same issue reflects there as well. what's the solution for this & what's the reason to happens this.

[Malsha]

Hi everyone,

when I export my report data to csv, time fields display wrong values. in the csv file, time fields display a date in every row. This is how power bi report shows the time fields.

This is how exported csv file shows the time fields.

I opened this as a text file also. but the same issue reflects there as well. what's the solution for this & what's the reason to happens this.

[vicky_ · Accepted solution]

Time values are basically just formatted integers, and so are dates - you can read more about it here. If you need the time value to show exactly as in the power BI report, you can use the FORMAT function to return the value as a string.