Excel Services data source behavior RRS feed

  • Question

  • Had to configure a spreadsheet as an Excel Services data source, and went through the motions to do that (setting up Trusted File Locations, granting permissions on the Document Library in MOSS 2007, defining named table in excel spreadsheet, etc)

    Was able to connect to the spreadsheet and preview the data in DD data source pane. Went ahead and created a KPI, scorecard and a dashboard. Everything worked fine.

    During the testing phase, some of the data cells were 'cleared out' in excel and the dashboard started showing ERROR!

    Back to the DD Data Source - Test Connection said "Connection OK", but the View tab showed error message "Error in Connecting to Data Source. Please verify the connection details."

    This only happens on the first row. Is that a known issue ?
    Friday, October 2, 2009 10:22 PM