Forum Discussion

rimah's avatar
rimah
Frequent Visitor
4 years ago

DirectQuery RLS

Could someone please tell me How I can configure RLS on a dataset using DirectQuery and import, in power BI? I have a table that imported and I added a role on it "UserprincipalName()" but when I tr...
rimah's avatar
rimah
Frequent Visitor
4 years ago

Thank you for your answer, unfortunately, I can not see the data, I don't have access,

 

but my question is about the table "TABEL" is DirectQuery so how can you see it here 

in my report when I can not see all the tables that are in DirectQuery mode in the "Role" second when I add a role like you did my data is not filtred I see all data (I am using Dynamic RLS  USERPINCIPALNAME).

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi rimah ,

 

Can you share your pbix file without sensitive data or some screenshot of your filter dax in rls role.

 

Best Regards

Community Support Team _ chenwu zhu

 

  • rimah's avatar
    rimah
    Frequent Visitor
    4 years ago

    As you can see I only can see the imported tables and the filter that I added does not work on the other table(DirectQuey)

    • julienvdc's avatar
      julienvdc
      Helper III
      2 years ago

      Hey rimah did you ever find a solution to your issue, I am facing the same.