Forum Discussion
RLS
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.
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.
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?
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.