Forum Discussion
Helper IIIPrevent exported text column from removing leading zeros
Hello all,
We have text columns containing employee IDs. Frequently those begin with leading zeros. The leading zeros are removed upon exporting to Excel csv file. Is there any way to force retaining the leading zeros?
Thank you,
Kirt
This behavior was noticed in the desktop export only. Once you publish to Power BI Service the data types should be respected and the export will function as expected. Alternative is to use paginated reports which will provide unlimited rows export as well as a subscription option to deliver the report attached to an email.
HTH,
Smitty
4 Replies
This behavior was noticed in the desktop export only. Once you publish to Power BI Service the data types should be respected and the export will function as expected. Alternative is to use paginated reports which will provide unlimited rows export as well as a subscription option to deliver the report attached to an email.
HTH,
Smitty
Kirt1965Thank you, Smitty. This was indeed the problem. Appreciate it.
- Kirt1965
I read that thread before posting. It was unrelated to the issue I was seeing.
