Using RLS on Power BI Online

[Anonymous]

I have used =username()  in Manage roles in Power BI Desktop within my Dataset. I have published to Power BI Online.

I do not know what to include under 'Security' within Power BI Online to ensure Users can view the data. 

I tried my own email address and 'tested as role' and the report shows all data as blank.

I tried leaving the Row-Level Security Members empty and that also does not work.

What do I include in the People or groups field in Power BI Online which associates with =username() ?

See image below.

[v-diye-msft]

Hi @Anonymous 

You should add all users to the role. There will be no harm for this. If the user is not in your Employee list, they will not see anything. If they are, they will have restricted access.

[Anonymous]

Hi @v-diye-msft 

How do I add all users to the role?

Thanks!

Jemma

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You can add their mail address one by one, or just put them in a group, and then add the group mail address.

But please note that you can only use the distribution list group and security group in RLS.

Also, I'd suggest you refer below posts for more reference:

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

[Anonymous]

@v-diye-msft when I use 'test as role' the RLS appears to work fine. However when I publish the report, and have users test, they can see all the data. 

I seem to be doing something wrong or am missing a step in all I have read. I guess I need to open a Microsoft ticket to get them to remote in perhaps and see what's what. 

[v-diye-msft]

Hi @Anonymous 

Did you add the mail address under security in dataset pane?

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#manage-security-on-your-model