Row level security not working in some workspaces

[v-mizade]

Dear Team, I have implemented Power BI row level security, it's working fine in one workspace but when I publish it to other workspace it fails to work. To test, I created tow measures one for USERPRINCIPALNAME() and other USERNAME(). In one workspace I can see correct user for "Now viewing as:" but other workspace shows my id and my applied rule not working. Can you please help?

Thanks,

Milind

[v-qiuyu-msft]

Hi @v-mizade,

As you mentioned "it's working fine in one workspace but when I publish it to other workspace it fails to work", are they they two app workspaces? 

/Would you please share some screenshots to clarify " In one workspace I can see correct user for "Now viewing as:" but other workspace shows my id and my applied rule not working"? 

Best Regards,

Qiuyun Yu 

[v-mizade]

Hi Thanks for your response, see below screenshots for the same PBIX in different workspaces, by the way I figured out the issue, if user is already a member in workspace, this was not working as expected, i just had to remove and add user back to the workspace and it's started working. 

[v-qiuyu-msft]

Hi @v-mizade,

Thanks for sharing the solution. As the issue is solved now, may I close this thread? 

By the way, please mask sensitive information in your screenshots. 

Best Regards,
Qiuyun Yu