Implement Static and Dynamic Row Level Security (RLS) in Power BI

Hi In this video we are going to see how to implement static and Dynamic Row-level Security (RLS) in Power BI.

Topics Covered
1) How to implement Static Role Level Security in Power BI
2) How to implement Dynamic Row Level Security in Power BI based on one dimension (by joining security table - USERPRINCIPALNAME Function)
3) How to implement Dynamic Row Level Security in Power Bi-based on two or more dimensions (without joining the security table using DAX)
4) Difference between static and dynamic RLS
-----------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------
Most Linked Videos -

#PowerBI #DataAnalytics #BusinessIntelligence

[harshtrivedi]

Great job brother. understood both the RLS use and steps. BDW your voice sounds like MSD :D

[ramarchenav]

Thank you, I was fighting with the Dynamic RLS and your tutorial helped me.

[parthakotapati]

Very clearly explained. I am going through your documentation/videos to prep for powerBi certification and found it very useful. Great work.

[shomeshkrishnan]

Hi, Thanks much for this good explanation in Dynamic RLS. In real time we encounter to filter many dimension tables with multiple values, say here one country and one product right, say we come across with three dim tables - 5 products, 12 countries and 30 sub products. How can do that?

[JenMayB]

Thank you. The multiple alert interruptions to like share subscribe was not good 😢

[debabratapanda]

Nice Videio. I have a query Here rather than one country if we want to have a user who while have multiple country or product access how we can do that

[kafiravadh]

I am getting error.
A calculated column or RLS expression on a DirectQuery table cannot reference tables from a different data source

[amitgajkal]

I am facing below challenge when i am uploading the file to my workspace and when trying to test it gives following error:
'To test row-level security, create a report with the semantic model and save it to the same workspace.'
i used your file, not sure why am facing this challenge.
Please help

[Mahesh]

then what the use of username(), if we are using userprinciplename() ?

[JannePavankumar]

HI,
if we share a report through embedded code we can apply security on report or not.

[GauravKapoor]

Hey, can you please help me with this issue. I am able to view the changes in power bi desktop but the changes are not showing in powerbi service version. I have also added email id's of filtered people in RLS of power bi service.

[jacobocastroestrada]

Hello, thanks for sharing this amazing video, I want some help. In mi data set the email I want to log in I need him to see not just one product, but 3 products and 2 countries, how can I do that?

[Iheartmusic]

When I create a role through RLS and then view it as the role I created, certain visuals do not change. Do you know why this might be the case?

[sanjeevkarthik]

For dynamic RLS again in services level we need to add email addresses manually??

[bajigunturu]

Thanks bro.. We are using power bi embeded.. We don't have the email address those emails embaded in web application.. Now how can we do RLS with power bi embaded.. Plz can you make a video

[harishs-dmmm]

can a user be able to dowload power bi report shared with the data asscociated

[beingrishi]

7:42 Id email I'd are not present in the data then what need to be done