Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exporting the data to CSV file

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?

 

Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    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.

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.