We can ensure record level filtering by user if we could just get the username! Please provide an option to pass the user name as a function parameter when establishing a function as a data source. ...
I also need a solution for the same problem. Unfortunatelly there is currently no way to pass PowerBI user name to azure sql and to apply SQL RLS there based on the user name.
