The report server cannot process the report or shared dataset

Question

I have a problem when I deploy my report project to a remote ssrs with the shared datasource. When I'm using the SQL Server data tool to "preview" my report, it's looks like have no problem. But when Y deply the project, this error message appear

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

---

noteworthy that the datasource it's pointing to the remote database

Answer 1

If you are using a report server, then perform the following steps:

1. Be sure you're on a version of IE this will not work correctly in Chrome
2. Go to your report server
3. Click on ... , on top-right of your report name
4. Click on 'Manage'
5. Click on 'Data Sources'
6. Make sure that Connect to: settings are pointing to the right places.

You would be amazed how many times this will happen because of a credentials issue or how the data source is setup. In the same case share data source will be in a different folder than the initial one. Maybe you will see a warning label.

Without more information about what kind of server you are using, this is all I can think of suggesting.