Exporting the data to CSV file

[Anonymous]

When exporting the PBI Report data to CSV file ,the format in the CSV file is getting weired format .

Example: there is a number in PBIX with leading Zeros - 000000123456789, but in the CSV file it showing 123456789 upon exporting the data to CSV and removing the leading Zeros.

Is there any way to fix this issue?

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can try this solution:

1. Delete ‘Change type’ in edit queries in power bi desktop, close & apply it.
2. Export data to .CSV file from power bi desktop
3. Open a new worksheet, choose From Text in Data ribbon
4. Select the file you have previous export, then click next to setp2 and select comma to next:
5. Change the data format into text, finish it
6. You will get the result like this:

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.