Forum Discussion

y5famfnatudu's avatar
y5famfnatudu
Icon for Resolver I rankResolver I
3 years ago
Solved

Securing report values using a RACI Matrix

Hello,   Is it possible to hide/show Revenue based on a RACI Matrix that is added to the data model?   The scenario is as follows: The above RACI Matrix indicates [who] is supposed to acce...
  • sturlaws's avatar
    3 years ago

    Hi, y5famfnatudu,

    based on the information you provided, I have createt an example on how this can be solved, attached at the bottom of this post.

    In general, you should look into dynamic row level security, using the DAX-function Userprinicipalname to detect the viewer of the report.

     

     

    Cheers,
    Sturla

    If this post helps, then please consider Accepting it as the solution. Kudos are nice too.