Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

RLS for Power BI Dataset

Hi 

 

I have question reagrding RLS for Power Dataset

 

-so i have a dataset "A" which is connected to report "A"

-dataset "A' is published/refreshed daily via PBI desktop

-Report "A" has no RLS

-Now I have created report "B" which is connected to PowerBI Dataset "A" ( using the Power Bi Dataset option in Enter Data)

 

my question 

How do I set RLS for report "B" only ? i dont want viewing rights for report "A" affected

 

Need Help

10 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous Not sure that is possible. RLS roles/rules are defined at the dataset level so the rules are going to be enforced on any report that uses the dataset. I can't think of a work-a-round at the moment. Perhaps a composite dataset for Report B where the RLS rules are placed on the local data model?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank u Greg

       

      is it possible to create 2 duplicate datasets?

      e.g A1 and A2 and both refresh together

      that way i can set RLS on A2?

  • Erokor's avatar
    Erokor
    Resolver II
    4 years ago

    Now, it's not quite the same as traditional Row Level Security. You could keep a list of what users get what level of access in one table and apply a "Security Group" or "Distribution Group" as the RLS check that table that is imported to both data sets and related as follows: 

    This would allow you to show access to a Dataset. The users will still have access to the reports, but the data within will be empty due to the filtering on the fact tables.