Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |