Forum Discussion

nirrobi's avatar
nirrobi
Helper V
8 years ago

Export data to csv missing leading zero

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.

Need Help

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    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's avatar
      nirrobi
      Helper V
      8 years ago

      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.