Forum Discussion
Kirt1965
Helper III
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 re...
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
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
Kirt1965Helper III
Helper IIIThank you, Smitty. This was indeed the problem. Appreciate it.