Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

1 Dataset w/ Multiple RLS rules?

  • 1.  1 Dataset w/ Multiple RLS rules?

    Posted Aug 13, 2019 10:06 AM
    I have a Master Dataset that is leveraged for many different Reports.  My problem is that different reports require different row-level security.  From a version control, I really only want to have the 1 dataset.  Are there any methods here to achieve this?

    ------------------------------
    Michael Greez
    Commercial Operations & Analytics
    Watertown MA
    5088576280
    ------------------------------


  • 2.  RE: 1 Dataset w/ Multiple RLS rules?

    Posted Aug 15, 2019 08:26 AM
    I was able to find the answer at @Reza Rad RADACAD:

    https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

    ------------------------------
    Michael Greez
    Commercial Operations & Analytics
    Watertown MA
    5088576280
    ------------------------------



  • 3.  RE: 1 Dataset w/ Multiple RLS rules?

    Bronze Contributor
    Posted Aug 15, 2019 03:36 PM
    Glad it helped. there are many other patterns of Dynamic RLS that I wrote about too. here:

    Static Row Level Security read this blog post.

    Dynamic Row Level Security read this blog post.

    Manager Level Access in Dynamic RLS This post 

    Dynamic Row Level Security with Users and Profiles This post

    Dynamic Row Level Security with Organizational Hierarchy This post

    Dynamic Row Level Security with Organizational Hierarchy and M2M relationship this post



    ------------------------------
    Reza Rad
    ------------------------------