cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

downloading csv file problem with numbers format

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper IV
Helper IV

Re: downloading csv file problem with numbers format

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

View solution in original post

4 REPLIES 4
Highlighted
Advocate V
Advocate V

Re: downloading csv file problem with numbers format

Hi @Chateaux83 

 

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

Highlighted
Helper IV
Helper IV

Re: downloading csv file problem with numbers format

That is the thing, it seems like it is not, for example it addes a lot of random zeros...

Highlighted
Super User IV
Super User IV

Re: downloading csv file problem with numbers format

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper IV
Helper IV

Re: downloading csv file problem with numbers format

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

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors