Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
20 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |