Row Level Security View As is not working as expected in Datamarts

[jobender]

When I setup Row Level Security in a Datamart and then run the View As to test the roles, the first role I test works as expected.  Any subsequent roles that I test during that session do not filter as expected and I either get all rows in the datamart or it still caches the original View as Role settings I tested first.  If I close out that session and try again, this time opening another role under View As, the first one works, but when I switch to subsequent roles, it does not filter correctly.

Pictures are below for reference.

_______________________________________________

Roles setup in the Datamart

 When I do View as Role and start with the AdventureWorksLT role, it works as expected...

When I swtich to the WideWorldImporters role, it still shows the filter for AdventureWorksLT and yes I clicked OK and reviewed the result set.  This screenshot is after reviewing the result set and clicking View as Role again.

If I close out of the Datamart, refresh my browser and come back in and try WideWorldImports first, it filters as expected.

But now AdventureWorks does not work...

[v-cazheng-msft]

Hi @jobender,

I can reproduce this issue and it has been reported internally(ICM 316057173). Will sync here once there is any update.

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft]

Hi @jobender,

May I know whether this issue still exist? For the product group couldn't reproduce this issue, they need the following info to investigate on it: RootActivityID, DatamartID, Network log traces (.har) file when reproducing this issue. If this issue presists, please send it to Emi Predmore for further research. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun