Time Type not getting detected in PowerBI

[treesa2010]

Hi Team,

Can you please help me.

PowerBI is unable to detect the time thats getting fetched from my file name ie Watches_20220315_095127. I think its causing error because it has 0 digit in the starting. All my other filename with time format is getting detected.i.e Watches_20220315_105127- workling.

[v-henryk-mstf]

Hi @treesa2010 ,

Thanks for your feedback. 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,
Henry

[treesa2010 · Accepted solution]

Thanks everyone it got resolved. I tried changing the type from text to time and i dont know it just worked.

[HotChilli]

if the field is 095127 it will work, if the field is 95127 it will not.

So, there are 2 options:

1. if the field originally has the zero (as it looks like it does e.g. Watches_20220315_095127) , it must be getting cropped/edited in one of the steps, so try and change that.

or

2. use Text.PadStart to put a 0 on the front 

[treesa2010]

When i refresh my powerbi report it gives the error. The data is in "text" type. I changed it to "time" type. 

[HotChilli]

Can you show the step which causes the error please and also what the data looks like on the step prior to this?