Forum Discussion
Is it possible to restrict SQL query result visibility by column data using RLS?
Community Champion
RLS is on row level, you can create rules and associate users on them (or dynamically)....
Also, depends on what parameters you need, it's possible to use on Power BI Service, but they are static for the users...
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Yeah, the static parameters make it a no-go. The access level needs to be dynamically adjusted based on user - that's why I'm inquiring on the RLS front. I know you can create rules with associated users with RLS - my question is if it's possible to do so based on query results. Everything I see in any tutorial or topic about RLS talks about adjusting the visibility of specific columns or visualizations. I can't find anything on how to make a row invisible based on its contents.