Format not working for calculation measure in olap cube

[cetutt1]

I have a calculated measure that is the number of hours minutes and seconds.

using format string hh:mm:ss.

When connecting with excel the data is displaed as expected.

EX:

00:06:17

When connecting with power bi the data is displayed as a date.

EX: 12/30/1899

I am not seeing a why to change the format in power bi

[ElenaN]

Hello,

Did you try the Modelling tab -> Date Time: Time option?

Regards,

ElenaN

[cetutt1]

It is a live connection. The modeling menu items are grayed out.