RLS is not filtering data in PBI Service but is filtered in PBI Desktop

[stilllearningbi]

My RLS is working fine and filtering through in PBI Desktop but when I test in PBI Service, the data are showing zero value for the fact table that are directly connected with Permission tbl whereas for the table that are not connected to that fact table, the value are showing for overall value and not restricted by RLS.

For relationship between Permission and Region tbl. I use Region column to connect both tbl

For Region and Sales tbl. I use Region column to connect both tbl

.

I also have included the user email in PBI Service security settings.

Until now, I still dont understand where did i go wrong

[Anonymous]

Hi @stilllearningbi 

Please confirm that  the RLS roles are applied to members who are assigned to the Viewer role in the workspace

You can refer to the following links:

Solved: Testing Dynamic RLS? - Microsoft Power BI Community

Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community

Power BI Row Level Security and Dynamic RLS | by David Ding | Analytics Vidhya | Medium

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stilllearningbi]

Hi @Anonymous 

I've created a new workspace and im not assigned any of the user as members of the workspace. I only assigned the user's email at the Security settings.

[Anonymous]

Hi @stilllearningbi 

Please check that in 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.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stilllearningbi]

I'm using USERPRINCIPALNAME() and assign that with email column