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.

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
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.