How to prevent PowerBI export to excel, change my data type from text to number

[Rookarumba]

Dear All 🙂

Not too sure if there is a solution for this but my users and I are experiencing this issue when we export data onto excel.

I formatted the column to be Text but when export onto excel/csv, it get converted into number and this causes some issues as we're products information that either start or end with '0'.

And this happened on both PBIRS and PowerBI Desktop version.

Appreciate any help in this

[Kris2x5]

What worked for me was exporting the file from PowerBI. Then opening a blank Excel file and choosing to Import "From Text/CSV." Through the import process, change Data Type Detection to "Do not detect data types". One thing to note is that when I did this, the column headers became a separate row, so I used the Query Editor to promote the headers again. 

[ashrin]

I have the same problem, I use this for now : https://convertio.co/csv-xlsx/

[Rookarumba]

@ashrin Thanks for the suggestion but my organization have strict data policy so I doubt we can use that 😞

I can always create a PowerQuery n index the .csv and transform it as Text but let hope my users know how to use it then 😞

[v-chuncz-msft]

@Rookarumba,

This might be caused by the automatic conversion by Excel.

https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-9...

[Rookarumba]

@v-chuncz-msft,

Sorry for the late reply, i'm aware that Excel will change it automatically.

& if i change the file to .csv, then the data type is fine but is there a better way to do it as the users who are not good with Excel and won't know how to use PowerQuery to open the file and convert it to Text.