Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
LY18
Helper I
Helper I

Issue when extracting decimal value from a table in csv

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!)visual.png

 

 

 

 

but in csv i got this :extractcsv.png

 

 

 

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

 

 

1 ACCEPTED SOLUTION
vjnvinod
Impactful Individual
Impactful Individual

@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

View solution in original post

2 REPLIES 2
vjnvinod
Impactful Individual
Impactful Individual

@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
Community Support
Community Support

@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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!