Issue when extracting decimal value from a table in csv

[LY18]

hi all

i got an issue when i try to extract a table from the desktop in csv format

basically it round all the number without decimal ... ;-(

in the dataset the value are correctly format as decimal "1.2"

in the visual i set it to only show 3 decimales

it looks like that (perfect!)

but in csv i got this :

the strange thing is that the last 2 columns are ok

the only difference is that these 2 last columns are "measures" .... while other are just data extracted for the dataset directly

I tried to play with my regional setting but could not figured how to make it work

does anyone have an idea?

many thanks in advance for your help

[vjnvinod · Accepted solution]

@LY18 

Go to modelling in the power BI desktop

and click on the column, and then click on the thousand separator in Modelling tab and also give decimal points there

[v-yuta-msft]

@LY18 ,

I have made a test but couldn't reproduce your issue. The data format is whole number in my test data and I also created several measures based on the column. After exporting to .CSV file, every data is as same as in table visual. 

For troubleshooting, please check if the power bi desktop is the latest version.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.