title: SSRS 2012 failed to deploy when having 2 datasets
body: <p>I'm trying to create an automated report in our reporting server. Previously I only have one dataset in my report and all calculation is based on that dataset. I deployed the report to reporting server and everything works fine.</p>
  
  <p>Now I need to further develop the report by adding one other dataset. The data set is created fine by using SQL. Now I have two datasets in my report:</p>
  
  <p><a href="https://i.stack.imgur.com/LiFBM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LiFBM.png" alt="enter image description here"></a> </p>
  
  <p>At this stage, I have done any calculation using DataSet2 but trying to deploy the report to the server. Then I get this error message: <strong>The definition of the report 'xxxx' is invalid</strong>.</p>
  
  <p>I tried to search online but couldn't find the exact case, even though there are some other situations causing this error. So I may need some help here to help me understand what caused this error.</p>
  
  <p>Also once I deleted this DataSet2, report can be deployed successfully. </p>
  
  <p>My current settings in SSRS are:</p>
  
  <p>I have one shared Data Source, these two datasets are both using this common data source. I tried to use two separate data source, it didn't work.</p>
  
  <p>This data source is also deployed in the reporting server.</p>
  
  <p>The two datasets haven't been converted to shared datasets or deployed. Even though I tried to convert and deploy, that didn't make any difference.</p>
  
  <p>The two datasets may have common field names. I also tried to use a totally different set of field names in DataSet2, but still that didn't make any difference. </p>
  
  <p>Not sure if I missed some config settings or what. Appreciated for the help.</p>