Text format changes after import from SSAS tabular

[Stefkus]

Hi all,

In my tabular model I have the field Duration2, it's calculated with DAX. The field is formatted as Text and displays the value of the field Duration (which is in whole number) in format hh(h):mm:ss (also if Duration has more seconds than 24 hours, for example: 122:33:44).

When I connect to this tabular model in Power BI something strange happens.

Somehow the hours become minutes, minutes become seconds (and are also rounded up), seconds disappear.

In Power BI I can't make any settings because I load from SSAS Tabular.

I hope this makes sense to someone because I'm completely lost...

Thanks in advance,

Stefkus

[v-ljerr-msft · Accepted solution]

Hi @Stefkus,

Have you noticed that the value of "Duration" column shown on the report is smaller(276 and 25, instead of 16529 and 1452)?

For Duration 276, the Duration2 should be "00:04:36", the value is right. So the format of Duration2 doesn't change, it works all fine on both side. I think it's why the value of Duration column that become smaller when shown on the report you should figure out. Maybe you have applied some page/report level filter? Or you're not showing columns from the same table on the Table visual? And that should be easier to check.

Regards

[Stefkus]

Thanks a lot, I think I was a bit sleepy at the time... 🙂

You pointed me in the right direction. It was working all along but SSAS exported to another databasetable than I was aware of...

regards,

Stefan