Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to Solution.
Thanks everyone it got resolved. I tried changing the type from text to time and i dont know it just worked.
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
Thanks everyone it got resolved. I tried changing the type from text to time and i dont know it just worked.
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
When i refresh my powerbi report it gives the error. The data is in "text" type. I changed it to "time" type.
Can you show the step which causes the error please and also what the data looks like on the step prior to this?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |