Forum Discussion
Duration on Query Editor vs Time on Visual
Hi Folks! Recently a friend asked me about durations with more than 24 hours. The point is there is an Excel workbook with a worksheet containing a column that represents a duration, but some val...
Hi Anonymous ,
Power bi not support time duration type, you can split the value to different fields to store its units(day, hour, minute, second), it should suitable for deal with time duration values.
In addition, you can also take a look at following blog to know more about these:
Regards,
Xiaoxin Sheng
Thanks, Anonymous .
My curiosity is the data type "DURATION" that I found on Query Editor. It is converted to a Decimal Number when I access de data on Visual.
Did you saw it?
Regards.
Hi Anonymous ,
Yes, duration type only works on query table side. It will been forced convert to decimal value when query table convert to data model table.
As I said, you can split it unit to different fields to keep accurate duration values.
Regards,
Xiaoxin Sheng