Forum Discussion
DirectQuery SQL WHERE clause inefficiencies when dimension is filtered
Hi everyone, I have a report that is a composite model that uses direct query to fetch newly changed values from DataVerse (we have a power apps integration where users can change values and we w...
One thing i realize that might be a suggestion here is putting the things im filtering on about DIMENSION_A in DataVerse. That is one solution for more traditional characteristics about DIMENSION_A. However, the report I have often filters on calculated measures that are specific to the user so this isnt a general solution to the problem.