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

[
{
"happylevel" :98.6
}
]

 

 

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

 

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

2 Replies

  • 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