Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic RLS

Hello Guys,  I want to Set Dynamic RLS in Power BI..The Requirment is like i have sample data set like Person Sales Pradnya 1000 Sam 2000 Rahul 3000 whenever Pradnya login to Da...
  • v-luwang-msft's avatar
    3 years ago

    Hi  Anonymous ,

    According your descrebution,you could create masked column to achieve it,the following article could solve your question ,it tells about"One of the questions I got recently is this: “I want users to see one another’s sales information, but not to see who others are! How can I do that in Power BI?”

    Doing something like above is a bit different from row-level security approaches. In this scenario, we do want the user to see other’s information, even how much sales they have made, But we do not want them to see WHO the others are.

    This is more a data masking scenario than a row-level security. However, because the question often comes from the users of RLS, I explain it under that category. This blog post is about an approach for the explained scenario above.

    "

    To learn more details ,refer:

    https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking 

     

     

     

    Best Regards

    Lucien