Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
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
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
@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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |