I create a Dashboard with excel reporting services report, later, I publish in a web site this dashboard; but when I open this dashboard the information is not update....What Can I review?....
If you have the secure store services set up then from within the connection properties dialogue box, hit the authentication settings button and select SSO. The SSO id will probably be ProjectServerApplication. If you did not set up the secure
store services, then look here for into on it.
http://technet.microsoft.com/en-us/library/ee662106.aspx
open the excel sheet within excel, go to the connection properties and make sure it is set to allow for auto refresh. also, there can be a bit of a time delay between when you publish a project and when the new data will show up in the excel report.
I check Refresh data when opening the file option in excel sheet, later, I save. When I open my dashboard by PWA, I have this message....The data connection uses Windows Authentication and user credentials could not be delegated
If you have the secure store services set up then from within the connection properties dialogue box, hit the authentication settings button and select SSO. The SSO id will probably be ProjectServerApplication. If you did not set up the secure
store services, then look here for into on it.
http://technet.microsoft.com/en-us/library/ee662106.aspx
