SSRS in Native mode with SharePoint data source-Collection of common programming errors

Hi Ninsr,

Thanks for posting your question here. Based on my research, it seems like this issue caused by the Catching Shared Datasets.

I guess that when you create the dataset in BIDS, the datasource helps you locate to the exact position of the list (such as http://intranet.mycompany.local/it). Actually, after first run, the results and the correct server URL has been cached. And then if you change the connection string, the report still displays the correct result when you preview it.

However, after you deploy the report to reportserver, when the report first run, it will get the data based upon the datasource and dataset again. If the connect string is not locate to the exact position of the list, you will meet this error, so please ensure that the connection string can locate to the exact position of the list.

Hope it helps you. For more information, please refer to:  Caching Shared Datasets (SSRS)

Regards,