cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Row-level security: possible to apply RLS on Desktop with on-premises deployment?

Hi,

 

As I understand the Power BI documentation on row-level security, RLS rules are defined on Power BI Desktop and subsequently applied when the report is published on Power BI Report Server.

 

We have a requirement for RLS to already be applied in PBI Desktop as some users should only see a limited dataset when exploring data with Power BI Desktop. Is this technically possible? I understand PBI Desktop would need to connect to PBI Report Server for the RLS rules for this to work.

 

If this is not possible we will need to figure out a way to do this in the DB level.

 

Thanks for the help!

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

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.

View solution in original post

3 REPLIES 3
d_gosbell
Super User
Super User

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.

Anonymous
Not applicable

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. 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.