Online "View as User" Row Level Security for Dataset Owners

[RoryNBi]

Hi All,

The desktop experience offers a very good 'view as user' experience to help with row level security.

Do we know if we can emulate that in the online environment?  As far as I can see because I'm a data 'owner' I can never apply a role to myself to see how row level security will be applied.

The use case in my business is that I would like to give one of my users the ability to control the roles the have access to, however if I give them access to the dataset they automatically get to see everything all the time irrespective of the role that they have had applied to them.

Please help as it's very frustrating.

[asocorrocognex]

If you have multiple reports built on top of a dataset, how do you choose which one will display once you click on "Test as role"?

[matteoumbri]

Hi @asocorrocognex I am also interested in testing other reports based on the same dataset. Have you found a solution for your question? Thanks

[asocorrocognex]

Sorry, no, I have not.

[phoenix_down]

I have found sometimes that opening the report, and then going to the dataset and viewing test as, will cause it to impersonate the most previously opened report. It's hit or miss though, but I've had some success with it. Please make a feature request for this! https://ideas.powerbi.com

[v-sihou-msft]

@RoryNBi

In Power BI Service, you can't "View as user", but you can "Test as Role".

To limit the access on your dataset, you should apply the row level filter with DAX expression under a role, and just add those users as members of this role. See: Row-level security (RLS) with Power BI

Regards,