Forum Discussion

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago
Solved

Help required to implement security...

For one of my security requirement. I will have following table as input and thinking of following table as output but dont think that is the optimized way of doing it. For lesser number of records i...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi pbiforum123 

     

    Please see follow the steps in the video.


     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi pbiforum123 ,

 

Not sure if i understand the question, but you can implement dynamic RLS (using USERNAME() DAX). By doing so, when a user views the report, he will be able to see his respective group only.

 

Thanks!

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago

Thanks for responding! I know how to implement security. So my question is not about that.

 

If you see the above post, I will receive the above table from the client to give access to certain groups. If the group name is blank, then it means that they should access to all groups. I know to get this work I need to have dataset as shown in the output table but as you know this is not the optimized way to implement this as when the volume of data increases creating one one record for each group is tedious job. 

 

So my question here is, is there is any better/optimised way to implement this.

 

Hope it is understandable now. Please let me know if you have any questions.