Solved: CSV Import Issue

Malsha · ‎08-23-2023

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_ · ‎08-23-2023

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.

View solution in original post

Malsha · ‎08-23-2023

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_ · ‎08-23-2023

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.