Forum Discussion
Solved
RLS with UserName()
Hello Community, I have two tables, Table A (state, population) Table B (username, state). Is there a way to setup RLS using username() to reference Table B(username) column to return the value...
Hi there, you can most certainly do this.
I would suggest reading my blog post, which just gives some explanations around when deploying to the Power BI Service and what to look out for.
And then here is a great blog post by Kasper De Jonge, in which he gives a working example how to get RLS working. And also provides a sample PBIX file.
http://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/
You addressed my concern perfectly. Thank you once again!
Hi
why i don't have (on the join) the option for “Apply security filter in both directions”...?
attach picture