Bart vd Bergh on 30 Sep 2015 02:55:49
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.
- Comments (4)
RE: User identity for row level Security
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
RE: User identity for row level Security
unfortunatelly this is not possibl ein direct query mode
RE: User identity for row level Security
'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.
RE: User identity for row level Security
This is already possible. You can use the USERNAME () function in Row Level Security. An explanation: http://sqlkover.com/dynamic-security-in-power-bi/