Export data to csv missing leading zero

[nirrobi]

Hi,

When I try to export data to csv from PBI Desktop with time column (HHMM format) the leading zero is missing.

For Example 0803 show as 803.

I tried to use

Move_Time = FORMAT( 'Status'[Time HHMM] , "0000" )

but it still missing the leading zero.

Can anyone assist please.

Nir.

[v-caliao-msft]

@nirrobi,

I have tested it on my local environment, I can get the same results as yours. It seems that excel change data type when loading your excel. 

In order to workaround this issue, you can create aempty excel and load csv file into this excel file.

Regards,

Charlie Liao

[nirrobi]

Thanks a lot!

The workaround work like a charm.

The problem is that I need this data to be used by end user (no PQ / M knowladge).

I "feel" that there is must be some kind of workaround that doesnt include PQ.