When using a DAX function to implement RLS it appears that the underlying dynamic SQL that is generated is extremely inefficient. The field I am using in the DAX function i.e. ProjectID = 49 is encapsulated in a COALESCE - this results in the index not being used on this field, therefore the dashboard appears to be very slow.
1 Comment
- Status added:Needs Votes
