Oracle PowerShell RealTime Push

[cassoli2019]

Good night,

I have been trying to send Oracle data via PowerShell for some time to stream to PowerBI, unsuccessfully so far.

I would be very grateful if someone could help me.

Below the script that I tried to assemble:

$endpoint = "https://api.powerbi.com/beta/aabfeafc-82d3-42f6-bec6-dba6ddbc5428/datasets/6712ca6e-2054-4e18-9583-c..."
while($true)
{
Add-Type -Path C:\ODP.NET_Managed_ODAC122cR1\odp.net\managed\common\Oracle.ManagedDataAccess.dll
$username = "username"
$password = "password"
$datasource = "datasource"
$connectionString = "User Id=$username;Password=$password;Data Source=$datasource"
$Qtde = "SELECT COUNT(CONHECIMENTO_ID) FROM FISCAL.CONHECIMENTO WHERE DATA_EMISSAO >= SYSDATE-1"
$TCte = "SELECT SUM(TOTAL_CONHECIMENTO) FROM FISCAL.CONHECIMENTO WHERE DATA_EMISSAO >= SYSDATE-1"
$payload = @{
"QTDE" =$Qtde
"TOTAL_CTE" =$TCte
}
Invoke-RestMethod -Method Post -Uri "$endpoint" -Body (ConvertTo-Json @($payload))
sleep 20
}

Tks

[v-diye-msft]

Hi @cassoli2019 

Sorry, I can't fix it on my side, please kindly raise your issue to support team for better advice:

https://powerbi.microsoft.com/en-us/support/