Forum Discussion
Leading zeros disappear while exporting to csv
Please refer to this:
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.
Thanks for your insights.
Doing this will make the header as a new row with comma delimiter and isn't very efficient way to access csv for my client. My client explicitly wants a csv as attachment from power Bi platform. When he/she opens the attachment they should be good from there without having to do other stuff as per their requirement.
Thanks
Memorable MemberHi Anonymous ,
unfortunatelly opening the csv the way you want is issue of Excel itself. I know it was not possible to open csv by default without changing format. Unless they developed this featuree recently, you need to use import dialogue.