What is Row-Level Security (RLS) in Power BI???

Hey man, do you have a video tutorial where A PowerBI report is created and connected to DEV environment, but once the solution is deployed to UAT, the dataverse in UAT should be use instead the DEV.

Patrick this was so simply put. Thank you!

Thank you for this video

You guys are amazing!! Thank you 😘

Perdón, pero me suscribí por tu remera! ❤

Thank you very much, i loved your explanation, easy and direct, i will sure follow you !!

Thanks for sharing your videos always enjoying to watch your videos

how much is the cost? I need to implement power bi and access control

Does row level security have to happen on individual reports or can you have a master table and incorperate it into other reports?

I did a google search, you popped up and had a sigh of relief. Thanks!

thanks for sharing!

Awesome👍

What happens if a user is assigned multiple roles which are independent and cross filtering at the same time? will it work as AND or OR?

Does that user parameter always have to be an email address or does a numerical employee code works?

Very useful video, thank you very much!

You are the best!

Thanks for this but can you also make a video to implement RLS from tables in database; which means all user entitlements are stored in tables in database and user access to be varied based on the user who logs in to Power BI service

wonderful video Thank yo!

Wonderful. Thank you!

And If I have multiple pages where this filter can be applied , will it be applied to all pages?

patrick shall be able to do rls based on product categories and territories along page level rls in a single dashboard can you

I have a doubt in this if you click on the test as a role only you can see the respective country data but ,After give access to respective roles and if you open report in usual way( not test as role) raw level security is not working
Could you please explain why?

Thanks for the informative video!

If Adam had access to France and Germany, would he get to see each one individually somehow where he could toggle between them, or would he see a summation of the two?

Hi Patrick
I would like to ask you for help with using RLS in Power BI
We have the following configuration
- Access SAP BW through SAP connector
- load data in import Mode
- we are using Desktop and Service
- gateway to access SAP with technical user

The problem is following
- the report creator is creating report in Desktop, and connects to SAP with his credentials
- base on his credential he can see only the data that is allowed from him
- he creates the report and publish the report to Service
- but he does not implement RLS
- in the Service is set refresh, but the gateway is set using technical user, which can see everything, and when the data is refreshed, all the data is downloaded. Then all the users, that open the report, can see all the data, because the technical user has more access. The report creator dos not implemented RLS.

the question is:
what is the best way to use RLS in this case? Is there a way how to force self-service users to set up RLS, so it cannot be bypassed?
Thanks

can you make this video again for 2022? It seems you can only do this in desktop app now? Thanks!!

Hi! Thanks for this video. Is it also possible to restrict access rights to the comments section? For example, if both user A and user B added comments to the dashboard, then they see only their comments and not of each other.

I thought this was very hard to implement... But its easy!

Thanks Patrick. You make things fun. To any one reading this, I was wondering if you have come to a situation where you implement RLS on all of your reports (let say about 30). The RLS is set so that users assigned to site A Active Directory (AD) group can only see data for site A, users assigned to site B (AD) group can only see data for site B, and so on. The issue now is that when a new site C is open, then all reports need to be updated and assignments need to be done in the portal. Is there any good solution for something like this?

Do we need premium workspace to use RLS??

i really like your channel . thank you so much.

Thank You..
How description is changed from Sales from all countries to Sales from Germany?

Gosh u so cool bro.

OMG! Thank you ! May I please know if this will work when you import the filtered report into Power Apps? Will users view the report based on the filters in Power Apps?

Great explanation!

You are the BEST. Thank you so much for always being so clear and thoughtful.

Nice! Thank you!

Thanks this helps alot! but when I click on the options I do not have security, does this have something to do with my licensing?

Hi, can you manage or configure the roles within PBI for the browser or is it desktop only?

I wished someone would make a video on RLS per user. We have over 1,000 branches and it is not feasible to create a role for each and everyone :(

Hi Patrick, please, how can we share this within a power bi app with extarnal user without giving access to the data at all? Thank you

can anyone say what are the types of RLS?

RLS is sorely missing the Default Role or Reader Role that everyone would be assigned by default when accessing the report.

LOVEE your videos. not sure why there is even one dislike here

Great tutorial that's concise and gets straight to it. I'm likely to need to implement this feature, really helps being able to understand the functionality so quickly.

It seems Patrick is huge fan of MARVEL 😊

Is it possible to create RLS for a live stream data in power BI? We cannot download a .pbix file for live stream so it looks impossible to create roles for live stream data. Any suggestions from you @Patrick?

Hai i want to take training for your class please

your presentation skills are awesome

LOVE your videos! Very informative and easy to understand

Hi how can you provide dynamic content in the manage roles section ?