Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

RLS

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 t...
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Icey
      Icon for Community Support rankCommunity Support
      5 years ago

      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's avatar
        Icey
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        Does the latest method meet your requirements?

         

         

        Best Regards,

        Icey