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.
Hey, I really appreciate the explanation! I'm planning to implement a single Power BI report for multiple clients and embed it into our website. Would you recommend using a single dataset with a customer ID to differentiate the clients, or is it better to use separate datasets for each client and bind them dynamically? Which approach would provide better performance and security when embedding the report, and how would I proceed with implementing that?
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?
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 ?
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?
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.
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?
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!
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 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
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
Thank you so much for making this video. Super helpful
15:33 I agree. Same situation. You are the only one. I am going to test it.
You are the one who explained to me the best Victor, please do not go away :( ❤
Hey, I really appreciate the explanation!
I'm planning to implement a single Power BI report for multiple clients and embed it into our website. Would you recommend using a single dataset with a customer ID to differentiate the clients, or is it better to use separate datasets for each client and bind them dynamically? Which approach would provide better performance and security when embedding the report, and how would I proceed with implementing that?
Awesome workaround buddy! 👏🏻 Keep up the good work! 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?
not able go get the option of bind parameter in the table
Man, this is a super useful. Thx!
Dil luut liya bhai ne!!!
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 ?
Great video, have you tried using it to change a server parameter?
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
how to do the same thing for Stored Procedure.??? as using stored procedure in DirectQuery is showing error
Super cool solution...
Can you use this in power bi service after publishing?
Hello, this video was very helpful, Thanks a lot!. But , I do have a questions what happens if User gets Edit access?
This is amazing. Thank you. I just don’t know how to make upn role that can see everything.
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?
Hi awsome video can we have the same kind of parameter done for regions instead of username?? Will it works
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.
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?
Smart - Thank You
Hi. it is great trick, that i am looking for, how about parameter with hierarchy, i am waiting
thanks
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!
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
Hey Arun, are you referring to Azure deployment pipelines?
@@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
Great sir
nice