Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Leading zeros disappear while exporting to csv

Hi all, I have a report on Power BI with column varchar from source cotaining numbers. After exporting the report to csv the leading zeros are being considered as number by Excel and getting removed...
Need Help
  • kakarot13's avatar
    kakarot13
    5 years ago

    Hi Anonymous ,

     

    I had the same issue. Unfortunately it's not a PowerBI service, Desktop or Report builder issue. It's actually the doing of Excel Application. Excel is converting the values into integer by default. I opened my csv file in Notepad and the data did look good with the leading zeros. 

kakarot13's avatar
kakarot13
Frequent Visitor
5 years ago

Hi Anonymous ,

 

I had the same issue. Unfortunately it's not a PowerBI service, Desktop or Report builder issue. It's actually the doing of Excel Application. Excel is converting the values into integer by default. I opened my csv file in Notepad and the data did look good with the leading zeros.