Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Real-time-streaming on Powerbi

Hi  we can't get til Real time streaming to work. Ther is no data comming in. All  the data is coming from powershell.  But if i take a report i can see the data comming in.   The powershell is lo...
APIS and Embedding
Data Modeling
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    You need to create a custom streaming dataset tile firstly and add your streaming dataset tile to the tile. Copy the endpoint url, the sample powershell code should be like pattern below:

    $dataSource = 'Server Name' 
$userName = 'Windows Name' 
$password = 'Windows Password' 
$database = 'Database Name' 
$connectionString ="Server=$dataSource;Database=$database;trusted_connection=false; user id =$userName;Password=$password;Integrated Security=False"
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connectionString
$connection.Open()
$query = 'SQL Query'
$command = $connection.CreateCommand()
$command.CommandText = $query
$dataset = $command.ExecuteReader()

$endpoint = "endpoint URL"
#push data to Power BI 
while ($dataset.Read()) {
    $payload = @{
    }
    Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
}
$connection.Close();
$connection.Dispose();

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

You need to create a custom streaming dataset tile firstly and add your streaming dataset tile to the tile. Copy the endpoint url, the sample powershell code should be like pattern below:

$dataSource = 'Server Name' 
$userName = 'Windows Name' 
$password = 'Windows Password' 
$database = 'Database Name' 
$connectionString ="Server=$dataSource;Database=$database;trusted_connection=false; user id =$userName;Password=$password;Integrated Security=False"
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connectionString
$connection.Open()
$query = 'SQL Query'
$command = $connection.CreateCommand()
$command.CommandText = $query
$dataset = $command.ExecuteReader()

$endpoint = "endpoint URL"
#push data to Power BI 
while ($dataset.Read()) {
    $payload = @{
    }
    Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
}
$connection.Close();
$connection.Dispose();

 

Regards,

Jimmy Tao

SarveshKumar's avatar
SarveshKumar
New Member
3 years ago

What Would be sql query ?