Forum Discussion

Malsha's avatar
Malsha
Icon for Helper I rankHelper I
3 years ago
Solved

CSV Import Issue

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. ...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    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.

Malsha's avatar
Malsha
Icon for Helper I rankHelper I
3 years ago

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.