cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ed-freeman
Helper II
Helper II

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

@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
Greg_Deckler
Super User
Super User

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.

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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

 

 

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





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

 

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Brilliant, thanks for your help everyone!

 

cc:/ @Greg_Deckler @parry2k @Mariusz 

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.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

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 Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors