Forum Discussion

Malsha's avatar
Malsha
Helper 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.

 

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.

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.

2 Replies

  • vicky_'s avatar
    vicky_
    Super 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.

  • Malsha's avatar
    Malsha
    Helper 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.