Hi Guys,
I've bad news about the security of visualize Excel Services Reports on Project Server 2010. Project Server offer out-of-the-box Report solucions based on Excel Services.
It sounds good and it's spectacular when you see it on demonstrations, but when you try to discover a little bit, you get a strange experience.
So, Excel Services throw querys to Report database retieving all projects/resources/fields... that you want to show a spectacular report with grafics and dynamic tables.
Even so, as you could think, the query and Excel Services don't apply the RBS Security... it's worse because it enables that a Project Manager can see all project of the whole company. :-S
We have noticed Microsoft about this point... i hope it will be solved quickly.
http://social.technet.microsoft.com/Forums/es-ES/exceles/thread/ed26d374-3223-482b-96da-70242bdceaad/