SSRS 2012 CTP Shared Datasets in SQL Azure

In preparation for my SQLRally Presentation in Dallas in May 2012, I’ve been investigating SQL Azure, using the SQL Server Data Tools to create SQL Server Reporting Services 2012 reports. One issue you might encounter is that your report runs perfectly well in SSDT, but does not run when it’s been deployed to SQL Azure. You might get the following error message:

  • 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.

Leave a Reply