Forum Discussion
Time Type not getting detected in PowerBI
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.
Thanks everyone it got resolved. I tried changing the type from text to time and i dont know it just worked.
5 Replies
Thanks everyone it got resolved. I tried changing the type from text to time and i dont know it just worked.
- HotChilli
Community Champion
Can you show the step which causes the error please and also what the data looks like on the step prior to this?
When i refresh my powerbi report it gives the error. The data is in "text" type. I changed it to "time" type.
- 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
v-henryk-mstfCommunity Support
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
