Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
1 year ago
Solved

Need assistance,guidance with Dynamic RLS

Hi , I need some guidance with Dynamic RLS. Attaching the sample pbix file https://github.com/suvechha/samplepbi/blob/main/sample_info%20-%20security.pbix   Sharing the sample data model.  ...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Super User
1 year ago

Please redesign your data model first. Implement a Star schema, and place the RLS dimension table on the outskirts so it can control the fact tables in the center.

  • ashmitp869's avatar
    ashmitp869
    Responsive Resident
    1 year ago

    Hi lbendlin 
    Is it not the correct data modelling ?
    Fact tables are :

     

       CurrentBudget
       TimePhasedBudget

       TimePhasedForecast 
       ActualCost
    Dimensions :

           CostItem
           Projects

     

    Please guide.

    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      Which table has the dynamic RLS mappings?

      • ashmitp869's avatar
        ashmitp869
        Responsive Resident
        1 year ago

        Projects having Project_id is linked to Core_UserProjects.

        I am using Dynamic RLS in the Core_UserProjects which has got email id of user.

        User = [Email] = USERPRINCIPALNAME()

         

         

        The security of this model should be.

         

        Userid 9 should only view the projectid assign to the user i.e 1 and 5

         

         

         

         

        Userid 7 should only view the projectid assign to the user i.e 1