Shared Data Source name error underscore characters added

Question

The name of our shared data source in RS (report server) is "AF1 Live Database" (no underscore characters - just spaces between words) and is the same in report builder in VS. However, the following error pops up when the RDL of this report is uploaded onto our company site and run.

(error we are receiving...)
The report server cannot process the report or shared dataset. The shared data source 'AF1_Live_Database' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)

We have no idea why the error reports the shared data source as 'AF1_Live_Database' with underscore characters? This appears to be the problem that keeps the report from running.

Answer 1

It appears the SSRS does not support spaces in data source names see here. Its always best to avoid using spaces anyways in names because it takes out one possible reason for problems and keeps life simple.