Question

Is it possible to restrict SQL query result visibility by column data using RLS?

I have an inventory management application that currently uses SSRS, and passes a user's access level as a parameter to determine what results can be returned. We're trying to start using Power BI instead, but since Power BI doesn't support the passing of parameters through a web application (without using Embedded, anyways, which we can't use), we are trying to implement RLS as a workaround. 

 Is it possible to create a role in RLS that allows a user to only see records with their access level or lower - I.e. based on the data being pulled from the SQL Server database? Most of what I see in RLS restricts visibility on visuals or columns, but I haven't been able to find anything on restricting access to actual data.

Answer 1

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...