Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RLS in Direct Query

Hi Guys   I created the below expression for RLS and it worked perfectly for my imported tables but when using the same for Direct Query it is giving me an error.   kindly help in sorting this as...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It doesnt solve the issue. 

     

    Is there a way I can change this expression as per the Direct query?

     

    [CompanyId]=
    CALCULATE (
    MAX ( Deals[CompanyId] ),
    FILTER ( Users, Users[LoginLevelName] = "Owner")
    )

     

    Regards,

    Himanshu

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      Nothing wrong with the measure! but CALCULATE is not allowed in RLS

      Did you try to implement RLS through the desktop instead of measure? if it didn't work then you might need to change the Mode of connection to Import mode at least for the User Table. But still you will need to use the RLS of the desktop.