Forum Discussion
RLS not working
Anonymous
Yep I created a measure, then created a column that resembles that measure.
In the Modeling section when I add the rule Username = Username() <<< should it be Username = "Username()" ??? with the quotes or without?
It should be without quotes.
You should have something like this in the "Manage Roles" pop-up.
Is the security/Email in your facttable or do you have a seperate table with you emails which has a relation to the table?
- If so then you should probably enable filtering both ways and Apply security filters in both directions if you have not already done so.
Anonymous
So the dataset has a few tables, some of which hold the username and some of which don't, and i've created joins/merges in Query Editor to get a single table which holds everything I need. All the tables come from the same SQL server though.
The relationship is two way between the source table and the new table. I tried having the report visualisations in the dataset and seeing if that works, but it doesn't. If I 'test as role' I see no data at all, whether I add my email address to the role or not.
But I open the published Power BI Report I can see all of the data. I guess that's because I published it so it's ignoring the restrictions for me.
I have no idea what i'm doing wrong.