Power Bi (DAX on RLS)
Hi all, I wanted to make relationship between the security table and the fact table without having the connection in the modelling part. FacSecAccess is the security table. So I'm planning to do RLS role that can filter which email (in table FacSecAccess) that can access particular permission/department in FacPrmsn table that connected to the Data table without having the connection between the FacSecAccess and FacPrmsn. Any idea on how to do this?
Data and FacPrmsn connection key = DEPT_C
FacPrmsn and FacSecAccess connection key = Prmsn/PRMSN
Posted Mar 23, 2022, 4:10 AM UTC
117