Is it possible for my user to see rows that aren’t assigned to them in our dataset? My expression seems to be working where everything in my managers table has access to all rows of data and only Captain Email and Captain Email2 are limited to specific rows of data where I assigned them.
One of our users said they could see some “fake” data that I was using as a test which was assigned only to me.
OR(IN(USEREMAIL(),Managers[Email]), USEREMAIL()=[Captain Email], USEREMAIL()=[Captain Email2])
There is a warning in the documentation: Our dataset is about 300 or so rows. Doesn’t seem that large to me.
What does inefficient mean?
"more complex Security Filters like the one above are typically inefficient when used with large datasets. "
We removed the fake data rows and I hope it’s just a glitch that needs some syncing and refreshing of data.
Weird. Any thoughts?