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.
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?
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!
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?
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 ?
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