View data with RLS in SQL server from certain perspectives in power BI desktop mode

[yelah3]

Hi, I'm testing Power BI desktop version with the source data from SQL server 2016 where RLS is implmented.

As I turn the security filter on from the On-Prem side, I'm not supposed to access/view any data from the PBI. But I want to see the data from certain user's perspective (users who are allowed to access to the database), just like the 'View as Roles' in desktop mode.

How can I suppose to do? Any advice?

Thanks in advance.

[v-shex-msft · Accepted solution]

HI @yelah3,

If your security setting are based on accounts and apply on row level, it is possible to filter unmatched data when you get data from power bi side with correspond accounts. 

If you mean object level security, current power bi desktop not support similar type of security who can dynamic change table structure. (it will return error when you switch credentials between users who has different security settings on columns)

Object Level Security using SSAS in PBI Service

Regards,

Xiaoxin Sheng