Design your BI semantic model with SQL Server data tools such that you define role-based security and associate users with roles directly in the model. The end-user in Power View only gets to see the data based on their role membership in the
model.
HTH,
Robert
Robert Bruckner http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.