Forum Discussion
RLS (ROW LEVEL SECURITY) do not work when i use USERELATIONSHIP in DAX
With this data model, i can caculate easily with USERELATIONSHIP in dax. But when i use RLS to grant permission to user, it get error.
However, i have known that "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."
Link
I have changed the Data Model by Merge Queries between crm_lead(all about lead-sale information) and sale_order(all about order information), but hr_daily_expense(all about ads spend/day) have really no foreign key with 2 other tables.
So how can i design a data model or use a method which can help me solve this problem with RLS (ROW LEVEL SECURITY)
2 Replies
- amitchandakSuper User
anhducvu00 , refer this old solution
https://community.powerbi.com/t5/Desktop/USERELATIONSHIP-and-RLS/m-p/787463
- VillezekevikingMost Valuable Professional
This is another solution 🙂
https://www.villezekeviking.com/alternative-to-userelationship/