How to ignore RLS parameter in the DAX on the report when it is embedded to the application

[SmilikaL]

How to Exclude RLS parameter in the dax measure to get the count of Clients by excludind RLS parameter Priciple clientID when the report is embedded to the appllication.

RLS parameter

 

I have tried using 'ALL' , 'Remove Filter' functions in the Dax measure. where in the desktop level if i pass principle clientid filter then it excludes that filter shows the entire count but when the report is on the embedded application it includes RLS parameter.

Please share any inputs that help me to resolve.

[AlexisOlson · Accepted solution]

This is RLS working as intended. The user should never be able to access data that the RLS logic doesn't allow them to, even if you use ALL / REMOVEFILTERS.

To get correct totals with RLS, you need to do some extra work. Here are a couple of good articles on this topic:

Computing accurate percentages with row-level security in Power BI - SQLBI

Calculating Total, and Percentages in a Row-Level Security Power BI Model - RADACAD

[v-tianyich-msft · Accepted solution]

Hi @SmilikaL ,

It is important to note that RLS is intended to enforce data security, and in some cases it may not be desirable or even possible to bypass it. If you need to show that RLS is ignored, consider creating separate metrics or reports that do not apply RLS!

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson · Accepted solution]

This is RLS working as intended. The user should never be able to access data that the RLS logic doesn't allow them to, even if you use ALL / REMOVEFILTERS.

To get correct totals with RLS, you need to do some extra work. Here are a couple of good articles on this topic:

Computing accurate percentages with row-level security in Power BI - SQLBI

Calculating Total, and Percentages in a Row-Level Security Power BI Model - RADACAD