Forum Discussion

Emmy66's avatar
Emmy66
Helper V
5 years ago
Solved

Implementing RLS

Hi, I would appreciate any assistance on this please. I’m trying to implement RLS on the attached model. My expected output should be such that a user in powerbi_users table can only have access to ...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Emmy66 

     

    According to your description, You need to set up RLS several times in different situations. 

    Like this:

     

    Then set the user that meets each situation in the pbi service.

    Follow the tutorial step by step:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Emmy66 

 

According to your description, You need to set up RLS several times in different situations. 

Like this:

 

Then set the user that meets each situation in the pbi service.

Follow the tutorial step by step:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Emmy66's avatar
Emmy66
Helper V
5 years ago

v-janeyg-msft , my appologies for late response. Thanks for your proposed solution. It didn't work in my case, so I had to result to creating a SQL statement which gets updated once any user is added to view the dashboard thru our application as pbi is embedded. Thanks again for taking time to respond to my request.