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 tried "View as Role" only the table that I added a role on it is filtred but the others are not. 

 

I can not see this when I add a relation between the imported table and the DQuery Table

 

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    rimah , Usually this is what we do, we take a global dimension and filter that using RLS.

    The global dimension is one which joins with all fact example like region, item, customer etc

    • rimah's avatar
      rimah
      Frequent Visitor
      4 years ago

      Sorry, but how can we add Rls on a DirectQuery table in power BI is it even possible.

      I am adding Rls on an imported table that is a global dimension but it's only filtering itself.

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

        Hi rimah ,

         

        You need turn off the apply security filter in both directions when you use RLS.

         

        Result:

         

        If you need more help, please share some example data.

         

        Pbix in the end you can refer.

        Best Regards

        Community Support Team _ chenwu zhu

         

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