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

[ed-freeman]

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.

[Greg_Deckler]

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.

[ed-freeman]

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

[Greg_Deckler]

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

[Mariusz]

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

[parry2k · Accepted solution]

@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!

[Greg_Deckler]

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

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

[ed-freeman]

Brilliant, thanks for your help everyone!

cc:/ @Greg_Deckler @parry2k @Mariusz