User identity for row level Security

[bart_van_den_be]

I'd like to have a generic userid that can be used to implement row level Security in sql2016. Something similar like DAX Username but then as a Global variable that can be used as a parameter for scope setting.

[koenverbeeck1]

This is already possible. You can use the USERNAME () function in Row Level Security. An explanation: http://sqlkover.com/dynamic-security-in-power-bi/

[frank42]

'It is still not possible to pass the powerbi user name to azure sql and apply a row-level security based on the user name there. @Koen The link you have mentioned filters the data in PowerBI not in Azure SQL.

[hans_mueller]

unfortunatelly this is not possibl ein direct query mode

[me35]

This may be similar to this request where we are trying to get User specific filters for RLS https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15684009-add-a-default-role-for-row-level-security