Forum Discussion

jswat21's avatar
jswat21
Regular Visitor
2 years ago

Implement RLS by passing username to Stored procedure on direct query mode

  • Implement RLS 
    Take userprincipalname() that resolves to the email id of the logged in user,and use it to filter User table that has Email column to get a single row filtered for that user.
    Pick up the userid from that filtered row and pass it to the stored procedure being called in power query on direct query mode.
  • The stored procedure takes this userid as an input parameter and fetches result but doesn't return user id as an output column
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jswat21 ，

    What is your question? What efforts have you made? Where are you stuck?
    If you are trying to call the result of userprincipalname() in a stored procedure, this should not be reachable yet.
    Tables/columns/measure created using DAX are not visible at the ETL level.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group