Dynamic filtering of values for RLS

[rajulshah]

Hello All,

Requirement: If a user is present in the table, table should filter down. But if the user is not present in the table, I want to show all the users. User will login and see the reports. Hence, the user is a signed in user into Power BI Service.

Hence, I want dynamic filtering for RLS.

Anyone can help would be a great help to me.

Thanks in advance.

[v-lili6-msft]

hi,@rajulshah

  you can use USERNAME() or UserPrincipalName() function to to use Dynamic row level security in Power BI like below:

ISBLANK(COUNTROWS(filter(Table1,Table1[Name]=USERNAME())))

For example:

this is my basic data

and i add two roles by this formula

Then i view as the roles

Assuming  that i am Wave3 

Assuming  that i am Wave9

Reference:http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

Best Regards,

Lin

[rajulshah]

Hello @v-lili6-msft,

Thank you for the reply. I have this approach as a back-up.

What we want is to filter the data in the advanced editor using function like 'USERNAME', i.e. functon like these in power query.

Do you have any suggestions or links that I can follow?

[v-lili6-msft · Accepted solution]

hi,@rajulshah

    After my research, I'm afraid it is difficult to achieve in Power BI for now.

advanced editor in power query is used to deal with the data source, and it couldn't filter data by credential that

log in Power BI service.

Best Regards,

Lin