RLS

simona0808 — Wed, 25 May 2022 15:21:44 GMT

Hello everyone!

I have an app with 2 reports. The first report is the main one including sensitive data, whereas the second report could be shared with everyone(no restrictions). What I want to achieve is to create a group with users give them access only to report 2 and restrict them from report 1. The reports should be in one app. Does someone have any suggestions how this could be done?

Re: RLS

ribisht17 — Wed, 25 May 2022 17:58:09 GMT

simona0808

Using the username() or userprincipalname() DAX function

You can take advantage of the DAX functions username() or userprincipalname() within your dataset. You can use them within expressions in Power BI Desktop. When you publish your model, it will be used within the Power BI service.

Within Power BI Desktop, username() will return a user in the format of DOMAIN\User and userprincipalname() will return a user in the format of user@contoso.com.

Within the Power BI service, username() and userprincipalname() will both return the user's User Principal Name (UPN). This looks similar to an email address.

>> Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

Regards,

Ritesh

topic Re: RLS in DAX Commands and Tips

RLS

Re: RLS

Using the username() or userprincipalname() DAX function