The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone, when applying RLS, this error showed up. Could someone help me out on this, please 🙂 Thank you!
Solved! Go to Solution.
@ronaldbalza2023 , refer
USERELATIONSHIP cannot be used when row level security is defined for the table in which the measure is included. For example, CALCULATE(SUM([SalesAmount]), USERELATIONSHIP(FactInternetSales[CustomerKey], DimCustomer[CustomerKey]))
will return an error if row level security is defined for DimCustomer.
https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-and-RLS/m-p/787463
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
@ronaldbalza2023 , refer
USERELATIONSHIP cannot be used when row level security is defined for the table in which the measure is included. For example, CALCULATE(SUM([SalesAmount]), USERELATIONSHIP(FactInternetSales[CustomerKey], DimCustomer[CustomerKey]))
will return an error if row level security is defined for DimCustomer.
https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-and-RLS/m-p/787463
https://docs.microsoft.com/en-us/dax/userelationship-function-dax