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

The greatest tutorials on PowerBi embedded with Row Level Security!
This can change the entire dynamic of the reports you embed. Applying dynamic parameters with row level security can greatly enhance the speed of your queries and your visuals.

0:00 start
0:16 The problem
1:57 RLS model
4:37 Removing RLS
5:16 Setting Dynamic Parameters
7:53 Adding Dynamic Filter
10:14 The Magical Filter
13:13 Hiding Chiclet Slicer
15:18 Outro

[aleksandarboshevski]

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.

[mayberry]

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

[JenMayB]

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

[elrevesyelderecho]

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

[Kiaanthepro]

Thank you so much for making this video. Super helpful

[capitanmelanito]

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

[RockyRocks]

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

[kumarprabhu]

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?

[subashiyer]

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

[anmfaisal]

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?

[sandeep_ok]

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

[truevaluebusinessintellige]

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

[blendaguedes]

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!

[nicolasalalu]

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

[puhgete]

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.

[nqszbej]

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

[AnnaWho]

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(),


)

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?

[dvooxjj]

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 ?

[MoonShine-bscl]

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

[amirhd]

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