Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi Team, I know there are many examples out there to look though but my example is not the same in terms of converting time which is in text data type to 24 hours time data type. Please see screenshot below. Any help would be appriciated.
Solved! Go to Solution.
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 4 |