Incremental Refresh

swise001  Hi 

Help me understand or correct me if I am wrong .

 Incremental refresh main purpose is to reduce the data freshing  time by reducing the amount of data to be refreshed (It will not cater my purpose of real time streaming data) 

For my purpose of real time streaming data , I need to direct query ( my only concern is performance and datasource stressing )

Have you tried pushing Dataset by Powershell ?   

$SqlServer = 'name';
$SqlDatabase = 'datebase';
$SqlConnectionString = 'Data Source={0};Initial Catalog={1};Integrated Security=SSPI' -f $SqlServer, $SqlDatabase;
$SqlQuery = "SELECT * FROM Table;";

$SqlCommand = New-Object -TypeName System.Data.SqlClient.SqlCommand;
$SqlCommand.CommandText = $SqlQuery;
$SqlConnection = New-Object -TypeName System.Data.SqlClient.SqlConnection -ArgumentList $SqlConnectionString;
$SqlCommand.Connection = $SqlConnection;

$SqlConnection.Open();
$SqlDataReader = $SqlCommand.ExecuteReader();

$endpoint = " My end point from the API  "

while ($SqlDataReader.Read()) {
$payload = @{  "Data That I get from API info"

}
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
}
$SqlConnection.Close();
$SqlConnection.Dispose();

The error I get is :

Please comment .

Cheers, 

Sangay.