<h1>POST api/reportserver/v2/data/sql/preview</h1>
<div>
<p>
Returns the preview data for the specified data connection.
</p>

<h2>Request Information</h2>

<h3>URI Parameters</h3>
<p>None.</p>

<h3>Body Parameters</h3>

<p>Data preview with parameters model.</p>

<a href="/implementer-guide/apis/rest-api/v2/previewdatainfowithparameters">PreviewDataInfoWithParameters</a>

<table class="help-page-table">
<thead>
<tr><th>Name</th><th>Description</th><th>Type</th><th>Additional information</th></tr>
</thead>
<tbody>
<tr>
<td class="parameter-name">PreviewDataInfo</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/previewdatainfo">PreviewDataInfo</a>

</td>
<td class="parameter-annotations">
<p>Required</p>
</td>
</tr>
<tr>
<td class="parameter-name">Parameters</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of <a href="/implementer-guide/apis/rest-api/v2/queryinfoparameter">QueryInfoParameter</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
</tbody>
</table>
<h3>Request body formats</h3>
<div>
<h4 class="sample-header">application/json, text/json</h4>
<div class="sample-content">

```json
{
  "PreviewDataInfo": {
    "MaxRows": 1396,
    "SelectCommandType": 0,
    "SelectCommand": "SELECT * FROM Orders",
    "CommandTimeout": 1398,
    "Name": "Northwind Oracle Connection",
    "Provider": "System.Data.OracleClient",
    "ConnectionString": "Data Source=Northwind;User Id=sa;Password=P@ssw0rd!;"
  },
  "Parameters": [
    {
      "Name": "OrderDate",
      "Value": "2024-01-15",
      "DbType": 6
    },
    {
      "Name": "Region",
      "Value": "North America",
      "DbType": 16
    }
  ]
}
```

</div>
</div>

<h2>Response Information</h2>

<h3>Resource Description</h3>

<p></p>

<a href="/implementer-guide/apis/rest-api/v2/system.data.datatable">System.Data.DataTable</a>

<table class="help-page-table">
<thead>
<tr><th>Name</th><th>Description</th><th>Type</th><th>Additional information</th></tr>
</thead>
<tbody>
<tr>
<td class="parameter-name">CaseSensitive</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
boolean

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">IsInitialized</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
boolean

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">RemotingFormat</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/system.data.serializationformat">System.Data.SerializationFormat</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">ChildRelations</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Columns</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Constraints</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">DataSet</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/system.data.dataset">System.Data.DataSet</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">DefaultView</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">DisplayExpression</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
string

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">ExtendedProperties</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Dictionary of Object [key] and Object [value]

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">HasErrors</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
boolean

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Locale</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/system.globalization.cultureinfo">System.Globalization.CultureInfo</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">MinimumCapacity</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
integer

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">ParentRelations</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">PrimaryKey</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of <a href="/implementer-guide/apis/rest-api/v2/system.data.datacolumn">System.Data.DataColumn</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Rows</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
Collection of Object

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">TableName</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
string

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Namespace</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
string

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Prefix</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
string

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Site</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/system.componentmodel.isite">System.ComponentModel.ISite</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">Container</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
<a href="/implementer-guide/apis/rest-api/v2/system.componentmodel.icontainer">System.ComponentModel.IContainer</a>

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
<tr>
<td class="parameter-name">DesignMode</td>
<td class="parameter-documentation">
<p>No documentation available.</p>
</td>
<td class="parameter-type">
boolean

</td>
<td class="parameter-annotations">
<p>None.</p>
</td>
</tr>
</tbody>
</table>

<h3>Response Formats</h3>
<div>
<h4 class="sample-header">application/json, text/json</h4>
<div class="sample-content">

<p>Sample not available.</p>
</div>
</div>
</div>
