Forum Discussion
emma313823
5 years agoHelper V
Restricting data
Hi I have a table which I need to add some restrictions to, but am not sure how to do this in the desktop app. First, all users have been upgraded to Power BI Pro. I want to restrict the data by t...
emma313823
5 years agoHelper V
Hi
Thanks for this link. I guess I'm still confused on what to do.
The article says...You can use username() within this expression. Be aware that username() has the format of DOMAIN\username within Power BI Desktop
I don't know what I'm supposed to put in for domain - is this something I obtain from the online admin account?
I selected my table and entered username([email protected]). I selected the check box and it shows I have some syntax error.
darentengmfs
5 years agoPost Prodigy
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
This link will explain to you how to use username() in row level security.