Forum Discussion

Stefkus's avatar
Stefkus
Frequent Visitor
9 years ago
Solved

Text format changes after import from SSAS tabular

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

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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.:smileyhappy:

     

    Regards

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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.:smileyhappy:

     

    Regards

    • Stefkus's avatar
      Stefkus
      Frequent Visitor
      9 years ago

      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