Power Bi : Using Row Level Security / UserPrincipalName with Dynamic Query Parameters 

Super cool, thanks for sharing. Default visuals sometimes does not align with our expectations, very cleaver that you've tried the chiclet slicer. You are creating very good content, keep up with the great stuff you are doing.

Ohh okay I was wondering how you would do that. This stuff is difficult but I feel like user friendly with you explaining all of this. Thank you

You are the one who explained to me the best Victor, please do not go away :( ❤

15:33 I agree. Same situation. You are the only one. I am going to test it.

Thank you so much for making this video. Super helpful

This is amazing. Thank you. I just don’t know how to make upn role that can see everything.

Dil luut liya bhai ne!!!

Awesome workaround buddy! 👏🏻 Keep up the good work! Thank you 😇

Can you use this in power bi service after publishing?

Great video, have you tried using it to change a server parameter?

VERY INNOVATIVE - BUT HOW CAN WE SECURE THAT EXTERNAL USERS NOT USING OTHER USERNAME INTEAD OF THEIR OWN? iF JOHN WRITES JUSTIN - HE WILL SEE THE DATA FOR JUSTIN - ISN'T IT?

Smart - Thank You

Thank you for the solution. I have few questions 1. Isn't it why we have SSO option available which allows to track the current user login to be able to sent to source and we can return the result based on the SSO user who is logged in currently? Also please advice how to scale this up..currently in the user table I have user name email, and I also have region table and then roles bridge table which contains the user permission details and along with org hierarchy..all these are dimensions....but how can I create relationships between these and still use dynamic M query parameter to filter direct query 2. So if we go by this approach, do we not need to add the users list or security groups in the RLS role in PowerBI service for the dataset under 'Security' tab?

I loved the video, perfection! BUT IDK what the heck is the problema that I can not find the bind parameters option, I deleted the connection, I updated the PBI version, I'm crying now. But thank you!

how to do the same thing for Stored Procedure.??? as using stored procedure in DirectQuery is showing error

I can't apply the filter to the query, I get the error "This query contains transformations that can't be used for DirectQuery." It wants me to switch to import mode, but then it wouldn't be direct query anymore.

not able go get the option of bind parameter in the table

Great sir

nice

Thank you so much, man! I wonder if there is a way to retrieve the username which logged in to the SaaS platform where the power bi report is embedded

Great video, thanks! I'm hoping you can help, I have a production report - I want the user logged in to view all the data but for the Employee Name, I only want them to see their name. I was able to do this with DAX: EmployeeName = IF( SUM('Production'[Quantity]) && SELECTEDVALUE('Employees'[LogInEmail])=USERPRINCIPALNAME(), SELECTEDVALUE('Employees'[Name]) ) However, if the user logged in is a supervisor, I want them to view all the data including all the Employee Names (my Employees table has a Supervisor column with a Yes/No value). Is this possible?

Hello, this video was very helpful, Thanks a lot!. But , I do have a questions what happens if User gets Edit access?

Thanks for sharing this. Will this approach help me apply RLS to members /admins of workspace too ? I tried this approach but its not working for users above viewer role. Is there any workaround in power bi where you can apply RLS to everyone including members/admins etc ?

Hi awsome video can we have the same kind of parameter done for regions instead of username?? Will it works

Hi. it is great trick, that i am looking for, how about parameter with hierarchy, i am waiting thanks

Hey brother ,i saw your video on using parameters to change sources . Can you make a video to change sources for deployment purpose . Bcz it will be different right ? For flat files can you do pls