Deploying a simple report with a shared dataset

Question

I've created a new SSRS project, and added a shared data source. When I run the project, I get the expected result succesfully.

However, when I try to deploy the report I get:

Error: Cannot deploy the report because the shared data source '/Data Sources/DataSource1' that the report references does not exist on the report server.

I'm guessing I am missing something very simple and critical because I am a complete beginner.

What am I doing wrong?

Answer 1

1. First, deploy the data source:

   

2. Then, deploy any necessary shared datasets:

   

3. Now, you'll be able to deploy or run your report.

Answer 2

If trying to deploy dataset but still getting this error...

I have discovered that if you change the name of the shared data source after you have already created a corresponding shared dataset, then the "DataSourceReference" property in the dataset does not change accordingly, is not be editable via the wizard, and it will throw this misleading error.

On the shared dataset, right-click and go to "Open With..." --> "XML (Text) Editor".

There you will see the raw configuration file. Make sure the <DataSourceReference> node has the proper value...