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

  Рет қаралды 7,503

Dapper Dash

Dapper Dash

Күн бұрын

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

Пікірлер: 25
@elrevesyelderecho
@elrevesyelderecho Ай бұрын
15:33 I agree. Same situation. You are the only one. I am going to test it.
@yogeshprasad2788
@yogeshprasad2788 16 күн бұрын
Dil luut liya bhai ne!!!
@aleksandarboshevski
@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.
@mayberry8169
@mayberry8169 Жыл бұрын
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
@capitanmelanito
@capitanmelanito Жыл бұрын
You are the one who explained to me the best Victor, please do not go away :( ❤
@RockyRocks
@RockyRocks Жыл бұрын
Awesome workaround buddy! 👏🏻 Keep up the good work! Thank you 😇
@JenMayB
@JenMayB 21 күн бұрын
This is amazing. Thank you. I just don’t know how to make upn role that can see everything.
@Kiaanthepro
@Kiaanthepro 4 ай бұрын
Thank you so much for making this video. Super helpful
@jrazafindrabe5229
@jrazafindrabe5229 10 ай бұрын
Smart - Thank You
@kumarprabhu
@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?
@tharanya
@tharanya Жыл бұрын
Great sir
@subashiyer3208
@subashiyer3208 8 ай бұрын
not able go get the option of bind parameter in the table
@johnkemp997
@johnkemp997 Ай бұрын
nice
@nicolasalalu6302
@nicolasalalu6302 2 ай бұрын
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
@puhgete 3 ай бұрын
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.
@user-dv3oo2xj3j
@user-dv3oo2xj3j 9 ай бұрын
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 ?
@AnnaWho13
@AnnaWho13 7 ай бұрын
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?
@blendaguedes
@blendaguedes 5 ай бұрын
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!
@user-nq7sz9be9j
@user-nq7sz9be9j 9 ай бұрын
Hello, this video was very helpful, Thanks a lot!. But , I do have a questions what happens if User gets Edit access?
@anmfaisal964
@anmfaisal964 8 ай бұрын
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?
@MoonShine-bs6cl
@MoonShine-bs6cl Жыл бұрын
Hi awsome video can we have the same kind of parameter done for regions instead of username?? Will it works
@amirhd2080
@amirhd2080 7 ай бұрын
Hi. it is great trick, that i am looking for, how about parameter with hierarchy, i am waiting thanks
@arunv1909
@arunv1909 Жыл бұрын
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
@DapperDash
@DapperDash Жыл бұрын
Hey Arun, are you referring to Azure deployment pipelines?
@arunv1909
@arunv1909 Жыл бұрын
@@DapperDash no bro , power bi deployments , for development, testing and production , in real time we wont use that? in that we need to change the source using parameters for checking , i need info for that , i guess not even one video on youtube for this topic
Power Bi : Setting up Dynamic Parameters
14:15
Dapper Dash
Рет қаралды 24 М.
Дибала против вратаря Легенды
00:33
Mr. Oleynik
Рет қаралды 4,8 МЛН
버블티로 체감되는 요즘 물가
00:16
진영민yeongmin
Рет қаралды 107 МЛН
Static and Dynamic Row Level Security in Power BI
16:28
PK: An Excel Expert
Рет қаралды 137 М.
Power Bi: Row Level Security using User Principal Name ()
5:45
Jese's Power Channel
Рет қаралды 18 М.
Row Level Security With Hierarchies
33:30
London Business Analytics Group
Рет қаралды 19 М.
Setting Up Power BI Row Level Security
57:03
Desktop Data Crunching
Рет қаралды 70 М.
Power Bi : Dynamically Change Data Sources using a Parameter
24:13
Power Bi : Use Local Images in Power Bi. 3 Different Methods
39:24
Мой инст: denkiselef. Как забрать телефон через экран.
0:54
ОБСЛУЖИЛИ САМЫЙ ГРЯЗНЫЙ ПК
1:00
VA-PC
Рет қаралды 864 М.
Самый дорогой кабель Apple
0:37
Romancev768
Рет қаралды 216 М.
GamePad İle Bisiklet Yönetmek #shorts
0:26
Osman Kabadayı
Рет қаралды 622 М.