Forum Discussion
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...
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
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.