Varchar column to milliseconds

[filipebodas]

Hello everyone,

I have 3 columns (nvarchar(50)) in a SQL table, that represent the multiple durations that occur in a call. As an example

duration_1	duration_2	duration_3
00.00:04:53.72000	00.00:00:02.83169	00.00:05:16.25872
00.00:03:45.00147	00.00:00:11.47080	00.00:04:23.09519
00.00:00:00.15138	00.00:00:00.00000	00.00:00:00.00000

This is in milliseconds, but when I connect this table to Power BI and change the data_type to Time, I get an error. How can I have the millieseconds? I need it to perform some calculations between each durations. 

Thanks!

[v-yalanwu-msft]

Hi, @filipebodas ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @filipebodas ;

I'm not sure what your raw data looks like (in SQL), powerBI allows you to change the display format,

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[filipebodas]

After formatting, if I do the calculations between them it preserves the milliseconds, which it was what I was looking for 🙂