Forum Discussion
Row-level security: possible to apply RLS on Desktop with on-premises deployment?
This is not possible if your pbix file is connected to your data source in import mode (so all the data is held in the model). The only way to do RLS with Power BI Desktop is to have the rules applied outside Power BI Desktop. So either in your data source and use a direct query connection. Or build your model in SSAS (and define the RLS in that model) and use a Live Connection from Power BI Desktop.
This is not possible if your pbix file is connected to your data source in import mode (so all the data is held in the model). The only way to do RLS with Power BI Desktop is to have the rules applied outside Power BI Desktop. So either in your data source and use a direct query connection. Or build your model in SSAS (and define the RLS in that model) and use a Live Connection from Power BI Desktop.
Hi d_gosbell,
Thanks for the response!
Why does DirectQuery vs Import matter if RLS is implemented in the data source?
Anonymous wrote:
Why does DirectQuery vs Import matter if RLS is implemented in the data source?
Because in Import mode a copy of the data is stored in the pbix file itself. So everyone that has edit access to the pbix file sees all the data stored inside it. The security on the data source is irrelevant until you do a refresh.