PowerPivot for SharePoint: Filter Security. One dashboard for different teams.

[freder1ck]

We are investigating PowerPivot on SharePoint to make a dashboard.
-Management needs to see all teams and granular detail.
-Each team needs to see its own data only, and only at high to medium level.

What option are available? I see that SharePoint has file level restriction only. Does this mean separate copies of the dashboard? Or does the data need to be split, and only those with access to a certain set could see it?

Thanks,
Fred

SQL Server 2012
PowerPivot 2013

 

[scottsen]

If you need "real" security, I think your options are going to be Files or SSAS in Tabular mode which offers row level security (you can filters stuff based on current user name).

You might be able to pull off some tricky stuff via username() and custom dax, but that sounds... painful.

If you are a bit more flexible... then you could hook up (say) a URL param, that feeds into a (hidden) slicer. The URL would control which report somebody sees. But obvioulsly, a diff URL could be used by... anyone to see other stuff.

Might be able to use USERNAME() to validate somebody is "allowed" to select the slicer value they did? That sounds interesting I might have to persue a blog entry on that

 

[freder1ck]

Might be able to use USERNAME() to validate somebody is "allowed" to select the slicer value they did? That sounds interesting I might have to persue a blog entry on that

Thanks, scottsen! This sounds like the best, using a lookup to pull the names and their teams from a SharePoint list. For internal users there's already a certain level of trust, but you don't want to temp folks with params like ?Team=red. That would make me try ?Team=blue just to see if it would work.

Fred