How to use DYNAMIC ROW-LEVEL-SECURITY (RLS) in Power BI // Beginners Guide to Power BI in 2021

Hi Fernan, thanks for the video and mabuhay from Manila. I have a question regarding the bi-directional cross-filtering:

Can we substitute it with visual-level filters or is setting bi-directional cross-filtering a must to enable effective dynamic RLS? I'm just a little bit worried because bi-directional cross-filtering has been frowned upon by many experts that I watch and follow, especially SQLBI and GIAC. Thanks!

Thx you ! I was looking for this exact feature. The fact that the dataset published will keep the RLS configuration is super interesting !

Amazingly explained

Excuse me, why did you checked the boxes for both “other user” and the RSL rule when testing on desktop?

My RSL only works if I do that exact thing (checking both “other user” and the RSL but not in web

Clearly explained; Thank you Fernan

Thank you very much! It was a very useful video, a quick question. When publishing the report do you always have to add the users in the “Security” section of the dataset or is there a way to automate that? Thank a lot in advance :)

The email you have usen there are your own email or you have written manually....

If one user is applied to all region, what will you do? Do you need to declare per line entry the region? Thanks

Thank you Fernan, I was havening problem with RLS after publishing what was pending was de Securit configuration on power bi service. You saved my day!

Amazing video! Thank you

Fernan, you are awesome mate !! Super clear and precise. Great Job.

How this works if we have another column country/city level access restrictions

Can anyone assist me? We have RLS per Group. We have a card visual with the group name. How do you get your visual to change (based on rls group) to show a short to long group name in the card? Or do you have an alternative solution?

Why did you create an extra "Region" Table in the Data Model? Can we not directly attach User Data with Permissions Table on "Region"? It will create a Many-to-Many relation, true but it would work, no? Basically what I am asking is what's wrong in many-to-many relation in such a scenario?

Thanks for this. Am I correct in assuming that user who we have provided dataset access will be able to refresh the dataset and visuals on the report with RSL applied?

I followed the same steps but when i am applying the email ID it changing the measure count.
e.g. Department A, Department B = total value is 1000, but when i am applying against email same these two departments changing 1000 to some other value
.what is that issue?

Great. Helped me a lot.Thanks.

Thank you !!! This is what I needed !!!!

thanks so much for this video, really helped me!

This was a very good explanation. Thank you for taking the time to do this.

Thanks Bro, Your tutorial saved me :)

Thank you Fernan - Very clearly explained. I've applied your lesson to my real life work scenario and it worked 1st time! Brilliant!

Superb. I really love this but what if my data source is a Cube/Tabular Model

great stuff

Great video, thanks for the help!

Covered all questions i had after reading the microsoft articles, you're a life saver, thanks !

Good video.
However, It's still based on offline data model.

How would you do it for the AAD users on large scalable datasets..?

Why are you checking BOTH the "other user" box and the "permissions" box when trying to view as in powerBi desktop?

Great Video

I really emjoy your videos! They are very helpful, thanks so much!

Great video and very helpful. Can we use rls and pls together using this procedure?

I watched this video to understand RLS and especially about if someone got the dataset will the RLS still apply as you showed at the end, and literally the VERY NEXT DAY my boss asked this exact question. Thanks man, you made me look good

Thanks for this great video.
How can I add multiple users/emails to view the same region's data? For example, if I want to add Bob to view what John can view.

The text you showed in video is blur. It would be helpful to provide a better resolution.

How I can get the dataset ?

Properly demonstrated

Really nice. All the details are covered. Nice pace and good example.

Great Video. Sorted out all questions we had on RLS in one go.

is it possible that the user may able to see the KPIs but not the table with detailed data?

Thanks for the details session. I have tried it but i am getting error on the power BI web service where it says "unable to load model". Whats the preferred relationship between the main data table and table contained email addresses?

Thank you so much for this wonderful channel,
I'm working with PowerBI Report Server, I have implemented Row-Level-Security and created one role on which every employee shall be assigned. However, I have over 200 users using the reports. Is there a way to automatically assign every email adress of the users to this single role?

please make a video visual hiding for example :we have 3 visual ,user A can access 2 visuals, User B having access 1 visual , User C having all visuals ,if you do this it will help me a lot

Can we automate updating the roles in Power BI service? Or, it’s always to be updated each time when we add/delete anything in the permission table?

Great explanation thx

Thanks for sharing the video. Instead of email addresses, is it possible to use AD Account names instead and UserName(). For some reason, this works for me locally but when deployed to the service it does not work

Great video about RLS. Beautifully and simple. It really gave me, what I needed about this.

Hi Fernan, thanks for the great content. I need to set RLS on multiple criteria. Like Region and Product. How can I do that?

Is anyone know when am checking one user the error show like Couldn't load the data for this visual

The query encountered security filters on a table relationship that cannot be reconciled for the current user. Please contact your administrator or developer to review role memberships and security definitions.
Please try again later or contact support. If you contact support, please provide these details.