- The report server cannot process the report or shared dataset. The shared data source ” for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)
The resolution for this issue is that Shared Dataset don’t seem to work properly, at the time of writing. The workaround is straightforward – don’t use a Shared Dataset. Here are some pointers:
– Make sure your data source is pointing to your SQL Azure Reporting Services Report Server URL. Test your connection works, and that it is using the correct login.
– When you create your report, don’t use a Shared DataSet. Instead, once you’ve set up your Data Source, go straight to creating your Report by right-clicking on the Reports folder and selecting the option ‘Add new report’.
You can then deploy the report to Azure, and it should work fine.
As an aside, you could try your report out on a mobile device. If you need any instructions, just take a look here.
I hope that helps! Any questions, please leave a comment.
Jen