Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Model performance issues due to complex RLS DAX code?

Hi community,   I have a question about RLS in our Azure Analysis Services at the model level, and whether the complexity of the RLS code can affect the performance of a PBI report connected with l...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    In fact, these type of replace operations will not obviously affect the report performance data loading.

    Normally the performance will been effect when you batch use Dax expressions with looping and iterators. Please take a look at the following link about Dax performances:

    DAX Best Practices | MAQ Software Insights

    Optimizing nested iterators in DAX - SQLBI

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

In fact, these type of replace operations will not obviously affect the report performance data loading.

Normally the performance will been effect when you batch use Dax expressions with looping and iterators. Please take a look at the following link about Dax performances:

DAX Best Practices | MAQ Software Insights

Optimizing nested iterators in DAX - SQLBI

Regards,

Xiaoxin Sheng