Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ellac
Helper III
Helper III

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 live connection. Namely, we are having performance issues for this particular report with this RLS solution, so I'm trying to dig into what the cause could be.

 

We have put RLS on a table because we want external guest users in our Azure Active Directory to be able to see a sales report, based on a specific vendor ID.

A separate table contains the guest users' email and their provider ID.

The RLS is set to their USERPRINCIPALNAME() with some changes made in DAX as we need to remove the email string which automatically gets some extra characters as they are guest users. See examples below.

 

USERPRINCALNAME() for guest user with email address "name@domain.com" becomes:
name_domain.com#EXT#@stadium365.onmicrosoft.com.

 

The DAX code in the RLS condition converts the string above to its original form "name@domain.com".

Long background… So, my question is – do you think it's worth optimizing this solution and get rid of the complex DAX code and maybe get a bit better performance on the sales report these guest users have access to?

If the complexity of the DAX code that sets the RLS condition does not affect the results of reports, is the mere fact that RLS exists making the report slow?

Sorry for such a long question, just let me know if you need more background. Thanks!

/Ella

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @ellac,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @ellac,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors