Forum Discussion

f1254lipm's avatar
f1254lipm
Frequent Visitor
2 years ago
Solved

Poor performance of calculation groups format string

Hi, I have a problem with slow performance when using calculation group formats from tabular model in SSAS 2019. I have a pivot table with 3 measures and when I was using just the measures the perfo...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI f1254lipm,

    It sounds like you faced the performance issue to process the Dax expressions.

    For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI f1254lipm,

It sounds like you faced the performance issue to process the Dax expressions.

For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

Regards,

Xiaoxin Sheng