Forum Discussion

TomatoKnight's avatar
TomatoKnight
Regular Visitor
3 years ago
Solved

RLS has moved to Power BI Desktop

Hi there,

 

I have a permission table build into my model on PowerBI desktop. When I login into service try to add email address under security. Below is the error message. 

 

I am currently on PowerBI Pro licence, I was able to set up RSL successfully in the past. Can anyone help?

 

 

  • TomatoKnight's avatar
    TomatoKnight
    3 years ago

    Hi CST,

     

    Thank you for your reply.

     

    In the past I set up the role called permission and used userprincipal function in Manage roles. 

     

    I have tried to use your method, it worked too. As number of people need to access to this model far less than last time. 

     

    Thank you.

     

     

     

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support

    Hi TomatoKnight,

     

    You can set RLS in the Power BI Desktop.

    Modeling->Manage Roles

    After setting it up here and then publishing to the service, your settings for the role will be published.

     

    You can refer this link below:

    Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

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

    • TomatoKnight's avatar
      TomatoKnight
      Regular Visitor

      Hi CST,

       

      Thank you for your reply.

       

      In the past I set up the role called permission and used userprincipal function in Manage roles. 

       

      I have tried to use your method, it worked too. As number of people need to access to this model far less than last time. 

       

      Thank you.