cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

Say I have an App backed by a Premium capacity. Say I have a report which has row-level security (RLS) configured on its dataset.

If I share that App with a user that has a Free license, will the user be able to view the report configured to use RLS? (Of course, I would have assigned them to a role before asking them to view.)

 

I've seen old posts which indicate that RLS is a Pro-user-only feature, but there's nothing in the current documentation (that I can find) which suggests that. I've also seen posts which indicate that it does not work, but it's not been clear whether those scenarios were using a Premium-backed App.

Unfortunately I can't test this myself, as I don't currently have access to a Premium capacity.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

@ed-freeman Yes it will surely work, I have done it many times. Here is  a full scenario:

 

- a workspace on premium capacity

- a dataset with RLS implemented

- users added to the dataset security (as a best practice it should be a group), users who need access to the app. These can be FREE users

- create an app

- add users or groups to the permission of the app so that user can install the app, these can be a FREE user

 

To test:

 

- Log in as a user without PRO license/Free User

- install the APP (if it is not auto-installed)

 

and that's it, you will see that RLS is implemented based on the RLS rule and the user will see their own data.

 

If you need more information, let me know. I can share screenshots with all the details.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

That should work with Premium capacity. Using Premium capacity you can absolutely have a Free user view a report backed by Premium capacity. The only reason I say *should* is the RLS. RLS is always a wild card but it absolutely should work.

The posts about Pro only feature were probably pre-Premium.

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Advocate I
Advocate I

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

Hi @Greg_Deckler ,

Thanks for the response.

Yes - it's the RLS part that I'm interested in finding a definitive answer to. It'd be easy to test, but I don't have access to a Premium capacity, so I'm wondering whether anyone knows the definitive answer from previous experience.

Regards,

Ed

Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

@Mariusz @amitchandak @edhans @ImkeF @darlove @parry2k @VasTg @az38 @HotChilli @Ashish_Mathur anybody have a definitive answer on RLS, Premium and Free users?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

Hi @Greg_Deckler@ed-freeman 

I remember setting up Dynamic RLS on Premium capacity, and I can't recall any issues, it was working with a client over a year ago and I don't have a way of double-checking.

Maybe someone with more recent experience can confirm, but the below article does not state any issues.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

@ed-freeman Yes it will surely work, I have done it many times. Here is  a full scenario:

 

- a workspace on premium capacity

- a dataset with RLS implemented

- users added to the dataset security (as a best practice it should be a group), users who need access to the app. These can be FREE users

- create an app

- add users or groups to the permission of the app so that user can install the app, these can be a FREE user

 

To test:

 

- Log in as a user without PRO license/Free User

- install the APP (if it is not auto-installed)

 

and that's it, you will see that RLS is implemented based on the RLS rule and the user will see their own data.

 

If you need more information, let me know. I can share screenshots with all the details.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Super User IV
Super User IV

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

Excellent! Thanks for the assist @Mariusz and @parry2k ! 🙂

 

It's great when you can call in the calvary!


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Advocate I
Advocate I

Re: Can a FREE user view a report configured to use RLS in an App backed by a Premium Capacity?

Brilliant, thanks for your help everyone!

 

cc:/ @Greg_Deckler @parry2k @Mariusz 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors