RLS

[Anonymous]

Hi, is there a way of implementing RLS and then changing the data visible in the Cards. For example, if general has Cost and User 1 has Cost multiplied instead?
or is there a DAX formula I can add to the overall report?

[Icey]

Hi @Anonymous ,

 For example, if general has Cost and User 1 has Cost multiplied instead?

---

Do you mean one visual show different kind of data for different people?

For example, there are three measures, "measure1", "measure2", and "measure3". When user1 reads the report, "visual1’ shows "measure1". And for user2 and user3, it shows “meausure2” and “measure3” separately.

Best Regards,

Icey

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

[Anonymous]

Hi, yes thats what I wanted.

If that is possible?

However, I decided to create another page, a duplicate and change the calculation for the new page to show a different cost, then I added a slicer with all the tables and an RLS and then hid the pages so only Users who are allowed can view other pages.

However, that method means bookmarks cannot be used as they would not be hidden so it is still unsecure.

[Icey]

Hi @Anonymous ,

It is possible. Please check:

Best Regards,

Icey

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

[Anonymous]

Thank you i will try that. However does that mean I have to include what the values will be for each user or is that automated? 

[Icey · Accepted solution]

Hi @Anonymous ,

Sorry to reply late.

You can also try something like this:

Best Regards,

Icey

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

[Icey]

Hi @Anonymous ,

Does the latest method meet your requirements?

Best Regards,

Icey

[negi007]

@Anonymous if I am right, you wish to write a measure that will override RLS implemented in your dataset. As RLS is applied to the dataset and it filter visible data based on the RLS. In this case, you may need to create seperate measure or table which will not get imapcted by the RLS.

You may try looking at the below link

https://community.powerbi.com/t5/Desktop/RLS-creating-a-measure-to-overide-RLS/m-p/37019

in case you have some other issue, please write back.

[Greg_Deckler]

@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

@Greg_Deckler 
So i've been asked to create Row level Security to manage access 

I have a Manager who requires all the data however, he has a team who requires limited data which isnt the same. 

For example, if he has the total cost and total profit as 'X' amount for all areas he manages he wants his team to have their own departments information but more than that he wants the information to be edited slightly to add 'X' amount to the value or to have the visuals pick up a different column. 

Also, If he can see a visual with cost and another with revenue, is there a way to change it for the team users so they see a different cost and revenue figure more related to their department?

[Greg_Deckler]

@Anonymous OK, so you could use a column security pattern: Column Level Security in Power BI - Microsoft Power BI Community

Also, there is now Object Level Security (OLS) in Tabular Editor: https://powerbi.microsoft.com/en-us/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/

Also, in theory you could use USERPRINCIPALNAME in DAX to identify the person and return the appropriate calculation.