Forum Discussion

Kasia1's avatar
Kasia1
New Member
2 years ago
Solved

text field treated as number while exporting to csv - missing zeros after a dot

hi! I have a PowerBI report that I need to export to .csv.  Some of the columns have different data types stored as text e.g. 12.300 or 89.2000. In .csv those values are being displayed as 12.3 or 89.2 but I need them with the zeros at the end. I tried the following:

1) making sure that the columns store data type as text in Power BI

2) disabling in options the detection of column types and headers.

3) the solution I encountered is to put a space or ' in front of the number, but it gets exported this way and I don't want the space or ' in the .csv in front of the value.

Is there a way to get the data exported correctly?

1 Reply