Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@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

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@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

What Would be sql query ?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors