Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

joemensor

DAX/RLS AND INDEXES

Submitted by Helper I on ‎08-18-2016 07:35 AM
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.
Status: Needs Votes
See more ideas labeled with:
1 Comment (1 New)
Comments
fbcideas_migusr
New Member
‎02-24-2025 08:56 AM
Status changed to: Needs Votes