Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX string filtering function in RLS with DirectQuery

I have a Power BI report that relies on DirectQuery to fetch data. One of the columns in the data is an e-mail address.  I would like to create a Power BI role which only allows a user to view data ...
Need Help
v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

I think this error message means that the FIND() function isn’t supported in Direct query mode, you should know that Direct query mode has a big influence on the use of DAX statement.

Limitation of FIND() function

 

I think you can try the CONTAINSSTRING() function or CONTAINSSTRINGEXACT() function and create a DAX statement like this:

CONTAINSSTRING ([Email],"@domain.com")
CONTAINSSTRINGEXACT ([Email],"@domain.com")

More info about CONTAINSSTRING() function in DAX

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.