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,
I have a problem with downloading the CSV file from a visual. The numbers get very messed up, it seems like the CSV cannot recognize when there is a comma, a .000 separator, etc.
Example: 7.567.456,34 becomes 756745634 , ot 3.111.855,22 becomes 31148552200000000.
It is strange also because there is no logic behind how numbers are changed it seems - the 2 examples are real cases from the same table.
How to fix this ? Can I do something on PBI, or have to work on Excel query editor ?
Thanks!
Hi @Anonymous
I'm pretty certain that, since it's exporting to a csv, it strips the data of any formatting.
The numbers should still be the same, is this not the case?
DJ
Proud to be a Super User!
That is the thing, it seems like it is not, for example it addes a lot of random zeros...
@Anonymous , A number needs to be converted to text, if it is common separated.
Like "7,000" as 7,000 are two columns in csv. But . should remain, unless it is the whole number.
CSV is not for formatted data. It is for Data.
Yes, that is clear. I partially solved this removing decimals from PBI, now it works. Still I don't get why the CSV would add 6 zeros to the number
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 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |