0

i am currently trying to create some Dashboard Reports using Power View for all Employees.

But i can't allow for any Users being able to see the Data of the other.

Is Power View capable of Determining which user is logged on and give that to my Tabular Project, so it can filter the data through the Dynamic Security implemented in the Tabular Model?

gberisha
  • 291
  • 5
  • 17

1 Answers1

1

If you are using tabular SSAS (not Power Pivot) and you have your security set appropriately (with roles and row filters), and you are connecting to a tabular SSAS model (through a SharePoint shared data connection or BISM connection) with windows authentication that uses the current user's credentials, you can take advantage of the security in your tabular model. Excel does have the capability to get the current user and pass that context back to the model to apply the appropriate security when returning results.

mmarie
  • 5,598
  • 1
  • 18
  • 33
  • Thanks for your Answer, Just to clarify, is this true only in Power View for Excel, or is this also true for Power View Reports created on SharePoint (Bism Connection - right click - Create Power View Report) ? – gberisha Apr 15 '14 at 10:17
  • The Tabular SSAS security will work for both Power View in Excel and Power View in SharePoint. If you go through Power View in SharePoint, you have to make sure you have Kerberos properly configured and service accounts and all that set correctly. – mmarie Apr 16 '14 at 02:05