Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
treesa2010
Frequent Visitor

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.

 

powerbi error.PNGpowerbi error_1.PNG

 

1 ACCEPTED SOLUTION
treesa2010
Frequent Visitor

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

View solution in original post

5 REPLIES 5
v-henryk-mstf
Community Support
Community 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

treesa2010
Frequent Visitor

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

HotChilli
Super User
Super User

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
Frequent Visitor

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

HotChilli
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.