Restricting data

Question

HiI 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 the user name within the data. So I have a column in the table that has the user. Is there a way for me to do this, so when they log into Power BI online, they see only the data assigned to them?&nbsp;The next level on this is within the table there is also a user called NBD, which is a generica bucket of accounts. I want each user to not only see just their data, but I want NBD to be included in this as well. Is there a way to also successfully do this as well?&nbsp;Emma

darentengmfs · Answer

Hi&nbsp;emma313823&nbsp;&nbsp;You can use Row Level Security (RLS) to do this.&nbsp;Here is an article to get you started.&nbsp;https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls&nbsp;&nbsp;

emma313823 · Answer

HiThanks 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&nbsp;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(bakerd@crowleyassociates.com). I selected the check box and it shows I have some syntax error.&nbsp;

darentengmfs · Answer

emma313823&nbsp;&nbsp;https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/&nbsp;This link will explain to you how to use username() in row level security.

anonymous · Answer

Hi&nbsp;emma313823&nbsp;,For your case, you need to set roles for thousands of users, so we need dynamic RLS.USERNAME() returns the domain name and user name of the current connection with the format of domain-name\user-name.&nbsp;It is worth noting that If a user has access to a particular row of data, they can see all the columns of data for that row. So we cannot use RLS to limit the columns or measures accessible by my users.&nbsp;Here are RLS related blog posts.https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bihttps://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bihttps://radacad.com/dynamic-row-level-security-with-power-bi-made-simple&nbsp;Best regards,Eyelyn Qin&nbsp;

Forum Discussion

Restricting data

4 Replies

Related content

Restricted View Policy Bug

Admin data policy 'dlpPolicy' restricts use of shared_onedrive with shared_office365

Restricting Export/Download of Reports with PII Data

Show restricted Data on filter panel

Restrict Get Data Options - SharePoint