Real-time-streaming on Powerbi

[Anonymous]

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 looking like this.:

[

{

"happylevel" :98.6

}

]

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

[v-yuta-msft · Accepted solution]

@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]

What Would be sql query ?