Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I need you support to fix an error when I import data from an excel file. I have a couple of columns and in one of them I have the time when each action happens. This time is written in minutes on the original file as the follow examples: 00:00 (Minutes : Seconds) and this happens as the follw 90 minutes : 55 Seconds and so on.
when I try to updoad this into Power Query it return "error" to values bigger than 23:59. I try to assign the type of data to text but it keeps returns the same error (for example 24 minutes : 05 Seconds).
Do you know how can I sove this issue to avoid to return erro?
Thank you in advance
Solved! Go to Solution.
You may check steps in The Advanced Editor.
You may check steps in The Advanced Editor.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |