SQL to Streaming Dataset

[Sdg8481]

Hi, i'm hoping that you can help.

I've been looking for hours but have been unable to find a solution. Basically i need to be able to link a SQL Server Database to act as the source for a Streaming Dataset in PowerBI.

I have been able to create a streamining data and a powershell script using the provided code, but i just don't know to get the dataset to be fed from the SQL server. I'm obviously missing the main part, but very stuck, so any help would be greatly apprecated. Please see details below:

SLQ Database details are:

Server = '10.8.35.99'
Database = 'TEST_TEST'

Table = MyDatatable

The PowerBI Generated Power Shell code:

$endpoint = "MYENDPOINTURL"
$payload = @{
"Extension" =98.6
"AgentState" ="AAAAA555555"
"DateTimeLastStateChange" ="2019-03-19T12:04:42.066Z"
"ReasonCode" =98.6
"SKillGroupSkillTargetID" =98.6
"AgentName" ="AAAAA555555"
"Duration" =18
}
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))

[v-shex-msft · Accepted solution]

Hi @Sdg8481 ,

You can refer to following blog to know how to use powershell to extract data from sql databse:

6 methods to write PowerShell output to a SQL Server table

Notice: please do mask on sensitive data.

Regards,

Xiaoxin Sheng