Excel Reporting Services Report in Dashboard RRS feed

  • Question

  • 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?....

    Thank You!!

    Wednesday, September 14, 2011 4:30 PM


All replies

  • 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.

    Wednesday, September 14, 2011 4:35 PM
  • 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

    Wednesday, September 14, 2011 8:27 PM
  • 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
    Wednesday, September 14, 2011 8:34 PM