Forum Discussion

URGO_Kniest's avatar
URGO_Kniest
Frequent Visitor
3 years ago

Problem with PowerBI (RLS) with Direct Query

Hello PBI Community, I have a question regarding using RLS in combination with DirectQuery connections. I have the following situation in my data model:     With this relation, I’m able ...
DirectQuery
RLS
Security
service
Smalfly's avatar
Smalfly
Responsive Resident
3 years ago

Hi there,

 

userprincipalname() fetches the Power BI login of the report user and then compares it to the value of the department column. Is it correct that the column 'department' contains the email/login of your endusers?

  • URGO_Kniest's avatar
    URGO_Kniest
    Frequent Visitor
    3 years ago

    Hi, 
    Thank you for your answer.

    That's correct, the field contains the email addresses and the territory (link to "sales markets ih") in another field.

    • Smalfly's avatar
      Smalfly
      Responsive Resident
      3 years ago

      I do see from your printscreen that the table contains the 2 fields email and department.

       

      Can you try to put your RLS on email instead of on Department and then try again?

      So: [EMAIL] = USERPRINCIPALNAME()