cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bjoern
Responsive Resident
Responsive Resident

RLS in PBI Desktop

Hi guys,

 

I am currently looking for a way to implement RLS in a PBI Desktop model. I have seen that via "manage roles" and using the username() function I can apply such feature.

 

But: How can I make it work for all users per default? As soon as I leave the "view as ..."-button, I can see all the data. Same accounts for all other users, I guess.

 

So, all other users should be able to open the PBIX-file, but should not have any chance to view all the data (i.e. they must stay in their role). How do I do that?

 

BR

Bjorn

 

 

1 ACCEPTED SOLUTION
ankitpatira
Community Champion
Community Champion

@Bjoern no i am not aware of any other way. if publish to service is not possible you should consider ssas or database level security. also on-premise hosting with ssrs is on roadmap but there is no timeline on when that will be out.

View solution in original post

3 REPLIES 3
ankitpatira
Community Champion
Community Champion

@Bjoern not possible yet in power bi desktop to enforce that, however that is not the correct way of using RLS or power bi as a whole. after implementing RLS you should publish that report to service and then share with users which will give you desired behaviour of RLS. if you intend to distribute datasets to other users and also want RLS you should consider publishing it as content pack.

Bjoern
Responsive Resident
Responsive Resident

@ankitpatira Thank you for the reply!

 

I am aware that a publish to WS scenario is more favourable. Nonetheless, it is not feasible due to data security restrictions. Any other ideas on that?

 

I would assume with the on-premise hosting via SQL2016 -> PBI reports via SSRS -> it should be feasible.? Otherwise, we would aim for SSAS or SQL2016 RLS. Do you have other thoughts?

ankitpatira
Community Champion
Community Champion

@Bjoern no i am not aware of any other way. if publish to service is not possible you should consider ssas or database level security. also on-premise hosting with ssrs is on roadmap but there is no timeline on when that will be out.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!