Static and Dynamic Row Level Security in Power BI

[@sandram5539]

I finished my studies last year, and at work to make a little place with my colleagues, it was very hard, because they have more experience. I can tell you now that the time for revenge has arrived. This is the first time I have found someone who explains well and makes you want to learn ! I promised myself that I would not put my laptop away until I finished all your lessons. Thank you so much
#yourlessons have changed my life.

[@lovethisgame23]

Solved questions that similar videos from other people failed to answer... thank you

[@PKAnExcelExpert]

Glad it was helpful!

[@unnikrishnansanthosh]

am quite new to PBI and your tutorials are a blessing . wonderful explanation thanks a lot PK

[@PKAnExcelExpert]

Thanks and welcome

[@its_sreethan_tinku]

Thanks for teaching us completely..

[@PKAnExcelExpert]

Most welcome

[@nosizweTT]

Thank you for simplifying this process..

[@PKAnExcelExpert]

Most welcome

[@theadventureguide3743]

Thank you for the step-by-step process.. it's very insightful.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@deepanchakkaravarthyc6358]

😅 super sir.. very nice n easy way explanation.. thank you...

[@PKAnExcelExpert]

Welcome 👍

[@bharath554-y2f]

Very clear and nice explanation thanks for the good video sir 👍

[@PKAnExcelExpert]

Glad you liked it

[@yashlokhande2859]

Really, this is great. Got all doubts cleared.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@snehalshrimanwar3721]

thanks for explaining RLS, VERY useful content

[@PKAnExcelExpert]

Glad it was helpful!

[@PawanSharma-ze6xr]

Very well explained sir...thank you so much...Grand Solute to you

[@PKAnExcelExpert]

So nice of you

[@DineshPingale]

Most useful information shared in simple way Thanks a Lot

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@prasadpatil9706]

Wonderful Explanation..!! Thank U 😊

[@PKAnExcelExpert]

Most welcome!

[@monicaramineni3563]

Solved my problem ...✌️well explained

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@atul1131]

good information, thanks

[@PKAnExcelExpert]

Glad it was helpful!

[@trevortrev8600]

This was super helpful, thank you so much for this tutorial!

[@PKAnExcelExpert]

Glad it was helpful!

[@RijwanKhan-kg1rl]

Thanks a lot. It's very helpful video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TrEndYWOrldviDeos]

Thankyou, really well explained

[@PKAnExcelExpert]

Glad it was helpful!

[@devenkumark]

Thank you for valuable information

[@PKAnExcelExpert]

Most welcome

[@rashmimkonnura1136]

very clear and neat explanation ..Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ankitpareek5986]

Thanks for this information. This helped me a lot.

[@PKAnExcelExpert]

Most welcome🙏

[@balavenugopal3269]

Very clear explanation

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@neetupandey7703]

Amazing explanation.. thanks a lot

[@PKAnExcelExpert]

Most welcome🙏

[@seemayadav-vf8mp]

Very well explained 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@whiitly]

Thanks !!

[@PKAnExcelExpert]

Most welcome🙏

[@surendrasopparapu4588]

Thank you so much brother....... It's so much usefull

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mohansaivelagapudi929]

Thanks for helping

[@PKAnExcelExpert]

Most welcome

[@sangabathunisivaramaiah7510]

Very nice explanation bro

[@PKAnExcelExpert]

Thanks 🙏

[@ksrinivas6215]

Good Explanation and information as well

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alivelumangmma319]

Superb explanation video with practical scenarios

[@Tamilminions.729]

Excellent

[@PKAnExcelExpert]

Thanks🙏

[@vinaygopal-e2u]

yeah very good explanation. thank you man

[@PKAnExcelExpert]

Most welcome🙏

[@tecnilogics6376]

Very good explain

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@anlithsimha9577]

Great content. Please upload more on POWER BI. Thanks in advance

[@PKAnExcelExpert]

Thanks for your valuable feedback. Will upload more videos ..

[@medkari]

THANK YOU FOR YOUR WORKS VER Y HARD

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vitheshrajan]

This is useful. Thank you. Can you please make a video on custom conditional formatting for Matrix Visual.

[@1918Janna]

what'll happen if you change many to many to one to many? ive read on some posts that many to many is no advisable so im kind of confused. but this video is soooo helpful!!

[@neharaju13]

Same here

[@SyedMuzammilMahasanShahi]

Thanks for the video. Good to see some Power BI tricks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vinodmahawer5395]

👍

[@PKAnExcelExpert]

Thanks

[@rochellerobinson939]

Another great video tutorial!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@harshalpatil2111]

Nice one.. thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@its_sreethan_tinku]

Sir one question you are editing in excel file and when you refresh in service how it is getting new data.

[@munisekharbhupathi7183]

Nice video

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Joshith_PeachyPrincess]

Hi will this rls work for direct query connections?

[@AnalyticswithProfessor]

Thank u

[@PKAnExcelExpert]

Most welcome

[@nicoi7662]

Excellent!

[@PKAnExcelExpert]

Thanks🙏

[@jobaeralam4915]

I hope you make a video on how to hyperlink in the dropdown list, very well done go ahead.

[@allaboutfoodzbydebd8627]

superb

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@trilok13579]

Great sir

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@balajithandavan6842]

Good❤️❤️

[@PKAnExcelExpert]

Thanks

[@86nareshc]

Thanks for the vedio sir

[@PKAnExcelExpert]

Most welcome

[@muralimohan71]

Why in Row level security page at 15:52 is not showing only two cities filtered for user. Its showing all cities.

[@BackBenchClub]

It is because he has published the report which is in his workspace using the same email address. He is signed in to his Desktop + Service using the same email ID which he has put in excel for those two cities. So in short, he is the admin of the dataset + the visual and hence he is able to see the visualization with all the cities.

[@muralimohan71]

@@BackBenchClub Got it. Thank you ☺️

[@BackBenchClub]

@@muralimohan71 Welcome :)

[@anuragbawankar685]

Thanks Sir !

[@PKAnExcelExpert]

Welcome

[@bhagyalakshmi1698]

Hi Pk nice explanation, here I have group names instead of mail id 's. How can I achieve with grop names

[@PKAnExcelExpert]

You can add group also in place of individual email

[@azvlogsblogs9272]

you took direct query?????? from excel to pbi desktop

[@yathishkumar9770]

hi, unable to test in services with the created roles

[@unnikrishnansanthosh]

Also, do you have any advice for deleting a particular row from PBI table

[@vinaypratapsingh5815]

Hi , could you please share the link of the excel file to download ? So that I can play with RLS more..
Its a wonderful videos which covers all the bases of RLS .. Thank you for sharing this videos

[@vasathi74]

Hi
Nice post
Could you make another video for multiple dimension tables and it's useful for everyone

[@PrideEnchantaVagale]

Thanks. But you added all in role. How does that work.

[@PKAnExcelExpert]

You can assign this role to whoever will see all the locations

[@soumikmishra7288]

This is a great video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ashwiniprashantwairagade2432]

where is the page level security video as you said it here. link please.

[@RohitThakur-ku8sb]

Hi , can u help me with how u added the below table, like month wise and every month also has qty and amout

[@its_sreethan_tinku]

please clear the last point sir how you are connecting excel to power bi desktop.

[@DilipTiwariVlogs]

Awesome!

[@PKAnExcelExpert]

Thanks🙏

[@dushyanthjangam6014]

Which city should I mention if I want to have all cities data?

[@nitirani8795]

how to get this excel file

[@Madhu-Reddy]

Can you please provide the link for page level security which is supposed to explain next day you mentioned in video end

[@jigneshbhuptani]

Hi, At the end of this video you mentioned about Page Level security video, can you share the link of that video..

[@monirulhasan4247]

Please share me link of page level security video.

[@mohsinshaikhanexcelexpert1196]

Very Good.
I want to learn VBA from basic to advance.
Can anyone have a notes orcan suggest a VBA website.

[@prashantshitole3832]

The roles are assigned and published on power Bi services and it is showing the data when we check as a test but not showing when we give the link to other user he can see the whole data and not only his own

[@nguyettran6118]

Hi!
Because my end users don't have Power Bi license and they also prefer using excel. So I generate an excel file that is connected to dataset on power bi by using Analyze in excel tool and send to end users, whether this Dynamic row level security will apply for the excel file that I generated too? If not, are there any way to set row level security for specific users in this excel file? Thank you

[@sagararora-e1x]

how to dynamically add user to access management table when ever a user is added into limited access location rule in power bi.

[@jobaeralam4915]

Very well, one thing I really need is how to make the hyperlink work in the dropdown list. The hyperlink will be any drive file. If I click on the drop-down list, the hyperlink will open.

[@monirulhasan4247]

please share me link for page leave filter video

[@jaijack6024]

how yu will map using live data

[@danjarupath]

What do you mean by Row in Excel ? Or Role?
I confuse.

[@deepakpandey7598]

Hi sir, How to add drill on drop box on donut charts. can you please provide details or make one video. I like this feature and wants to implement in my dashboard.

[@sanilalkuttimon1755]

😍😍😍

[@PKAnExcelExpert]

Thanks

[@TheChandansss]

Gem of a video this is :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shakthivel9741]

How do i caculate dynamic ranks of this location ex if new delhi rank is 4 when we views as normal user if we apply row level security new delhi rank is showing 1. i want it to show the same rank even if we apply row level security

[@RohithN10]

The Dynamic Solution is impossible what if i have 1000 users? I have to manually type locations for every user?

[@PKAnExcelExpert]

You have to create a Seperate table in database

[@lalithajakkula3941]

Hi Sir, after watching your video I tried Both of them, I perfectly got static row level security but the Dynamic row level security last part which is when you click on refresh button in power bi desktop it shows you the data of New York and Londan. but to me it doesn't show any thing the file report shows nothing. Why it happend to me

[@_BhatiaDev]

I want to create a dashboard through MS access, please create a video

[@dorachandrasekhar4827]

can you please provide link to page level security?

[@garudabowo]

Why many to many relationship?

[@neharaju13]

Your explanation was simple and easy to follow until you explained about dynamic RLS and talked about userprinciple name. It felt kinda rushed and not simple to follow. And unfortunately that was the part I mostly wanted to know.

[@Pooja-uu4ro]

and was very confusing

[@midhunmv3814]

Thanks for the wonderful tutorial 👍🏼

[@PKAnExcelExpert]

Most welcome

[@acommonman155]

Thanks a ton

[@PKAnExcelExpert]

Most welcome

[@simuislam5752]

Nice video

[@PKAnExcelExpert]

Thanks

[@krisy8434]

Awesome!

[@PKAnExcelExpert]

Thanks!