Implementing ROW LEVEL SECURITY - STATIC vs. DYNAMIC RLS | Power BI

Lets understand what is RLS and how to implement basic STATIC RLS vs. implementing more advanced DYNAMIC RLS.
1. What is RLS
2. Implementing STATIC RLS
3. Implementing DYNAMIC RLS
Data Used
www.kaggle.com...
Visit my blog for more content :
www.pivotalstats.com
Cool tech I use to produce these videos (affiliate links)
1. Blue Yeti Microphone -
amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor -
amzn.to/3EaHY8v
#Microsoft
#powerpivot
#dataanalytics
#dataanalysis
#powerbi
power bi row level security,power bi,row level security in power bi,row level security,power bi tutorial,power bi desktop,power bi tutorial for beginners,power bi training,dynamic row level security in power bi,power bi rls,power bi for beginners,dynamic row level security power bi,power bi dashboard,power bi row level security userprincipalname,rls in power bi,row level security power bi desktop,power bi desktop row level security

[@Sanj20101]

Watched many videos for RLS security but this one was awesome and easy to understand. Thank you bro. Keep it up. Learned lot of things from you

[@pivotalstats]

It's my pleasure. Thanks for watching!

[@rajpadwekar5974]

Very informative video! I was wondering if RLS would be implemented on the entire report, i.e all the three pages as shown in the video?

[@pivotalstats]

Yes, RLS will be applied on the entire report.

[@akupatichiranjeevi6159]

In addition to my previous i wnat to add one more thing is
1.your voice is very crystal clear
2.plese keep on doing more videos on Complex DAX
3.Deployement pipeline also sir

[@pivotalstats]

Thank you! Sure I will try to bring some videos on deployment as well.
Checkout the full DAX masterclass video -
ruclips.net/video/4rC9Ow76n0U/видео.htmlsi=94dRzhhuLyHLxAtX

[@contactsaurabhsomani]

OMG!!! I was looking for this trick for over an year. Thank you!

[@pivotalstats]

Happy to help! 🙂

[@akupatichiranjeevi6159]

Very informative video. No doubt about it only issue is that background music and after publishing it to service don't we need to add the requirement?

[@pivotalstats]

Thanks for the feedback! I have resolved that background music issue in my latest videos. Hopefully it will not be a problem going forward.
If you are using Dynamic RLS then you define the roles in the PBI desktop and don't have to setup anything on the services. Hope I answered your query!

[@PallaviSatpute-i6s]

Superb Explanation .

[@pivotalstats]

Thank you 🙂

[@SKumar-tw8jj]

If I have many datasets so how can give separate report wise permission

[@pivotalstats]

So if I understand you correctly, you have multiple dataset and each dataset is used to create a different report (different Pbix files). Then in this case each Pbix will have a separate RLS. So it will work just fine.
However if you are asking how to give different permission to multiple datasets in the same pbix file then I think you can do it by creating multiple User Role tables and connecting them separately with each of your dataset. for ex: UserRole1 >> Covid_India ; UserRole2 >> Covid_USA. Hope it helps!

[@remembernaveen30]

Thanks for great video :) , My query is the user level needs licesnce to view the dashboard ?

[@pivotalstats]

If you have a premium license then user can use without license. Otherwise user will also require license to see the dashboard online.

[@remembernaveen30]

Thanks for kind reply .i want to have Power BI Premium per capacity (includes Microsoft Fabric) or Power BI Premium
per user@@pivotalstats

[@janmejayamishra9308]

Great explanation... thanks so much😊

[@pivotalstats]

Welcome :)

[@ZOOTOPIAAAA]

hello !!
is it a good idea to create primary and foreign on the table,,, some times many to many relationship cause different result in the report,,

[@pivotalstats]

While applying RLS, you would often be in situation where many-many relationship is required. So I think its a good tool to have. However in all other scenarios, I personally try to avoid using many-many relationships.

[@Murali_IT]

Excellent explanation sir.💥💫

[@pivotalstats]

Thanks buddy!

[@venkataakhilmanduri8354]

Superb

[@pivotalstats]

Thank you! Cheers!

[@premkumar-on8ko]

very helpful video, could you publish power bi services video , like deployment ,data mart , gateway , how to create mobile app.

[@pivotalstats]

Yes sure, ill plan something for future videos!

[@Resh_Aadil_AllaboutExperience]

Great explanation👌👌👌

[@pivotalstats]

Thank you 😃

[@MuhammedSwalihT]

Nice 😊👍🏻

[@pivotalstats]

Thanks 😊

[@joebanks5420]

The music is annoying.

[@pivotalstats]

Noted, Thanks for the feedback !