title: SQL Server 2016 Report Builder not showing data
body: <p>The Database I am using is Microsoft SQL Server 2016 and its on a different machine. <br>
  I am using SQL Server 2016 Report Builder (14.0.344.82).</p>
  
  <ul>
  <li>I create a new report. <br></li>
  <li>Then I create a Data Source. <br></li>
  <li>Then I create a Dataset of "Text" Query type, the query I wrote has
  no parameters and returns a result set of 2 columns. <br></li>
  <li>Then I create a table and link its columns with the fields of
  dataset.</li>
  </ul>
  
  <p>Now I run the report inside Report Builder. I can see through the SQL Profiler that the concerned query is executed. But I dont see the data in the Report Builder. How come? I ran the concerned query in Microsoft SQL Server Management Studio and it return 8 rows. So I should have seen 8 rows in Report Builder. But I am not seeing a single row. </p>
  
  <ul>
  <li><p>I right-click the dataset to open right-click menu, then click on "Query..." menu option to open “Query Designer” dialog box; then I Run Query in there and I can see 8 rows are retrieved. So the dataset is fine. </p></li>
  <li><p>I dont have any filters for the dataset. </p></li>
  </ul>
  
  <p>Thanks</p>