Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
# Import the PowerBI Powershell Module
Import-Module "D:\home\site\wwwroot\myapp\bin\PowerBIPS\1.2.0.8\PowerBIPS.psm1" -Force
# Add a reference to the AzureAD Active Directory Client Library
# Used by the PowerBI Powershell Module for AuthN to AAD.
Add-Type -Path 'D:\home\site\wwwroot\myapp\bin\AzureADPreview\2.0.0.33\Microsoft.IdentityModel.Clients.ActiveDirectory.dll'
# PowerBI ClientID, AAD Username and Password
# From Application Settings
$clientID = $env:PBIClientID
$username = $env:UID
$pwd = $env:CredKey | convertto-securestring -AsPlainText -Force
$credentials = New-Object System.Management.Automation.PSCredential $username,$pwd
# AuthN to PowerBi/AAD and get Authorization Token
$authToken = Get-PBIAuthToken -clientId $clientID -Credential $credentials
$authToken
# Sensor API URL's
$outdoorhumidityURL = $env:humidity
$outdoorTempURL = $env:OutdoorTemp
$IndoorTempURL = $env:IndoorTemp
$outdoorLuxURL = $env:Lux
# Date
# Get Date for where the sensors are, not the date where the Azure Function is running
$date = [System.TimeZoneInfo]::ConvertTimeBySystemTimeZoneId([DateTime]::Now,"AUS Eastern Standard Time")
$strdate = $date.ToString("yyyy-MM-dd HH:mm:ss")
$strdate
# Outside Sensors
# Temp
$currentOutsideTemp = Invoke-RestMethod $outdoorTempURL
$currentOutsideTemp.celsius_degree
# Light
$currentOutsideLux = Invoke-RestMethod $outdoorLuxURL
$currentOutsideLux.lux
# Humidity
$currentOutsideHumidity = Invoke-RestMethod $outdoorhumidityURL
$currentOutsideHumidity.humidity
# Inside Sensors
# Temp
$currentInsideTemp = Invoke-RestMethod $IndoorTempURL
$currentInsideTemp.temperature
$currentInsideTemp = [math]::Round($currentInsideTemp.temperature)
Write-Output "Environmentals for: " $strdate
Write-Output "Temperature is: " $currentOutsideTemp.celsius_degree
Write-Output "Inside temperature is: " $currentInsideTemp.temperature
Write-Output "Humidity is: " $currentOutsideHumidity.humidity
Write-Output "Light is: " $currentOutsideLux.lux
# Outside PSObject with Env Data
$outsideEnvData = New-Object PSObject -prop @{
DateTime = $strdate
OutsideTemperature = $currentOutsideTemp.celsius_degree
OutsideLight = $currentOutsideLux.lux
}
# Inside PSObject with Env Data
$insideEnvData = New-Object PSObject -prop @{
DateTime = $strdate
InsideTemperature = $currentInsideTemp.celsius_degree
}
# Get the DataSet where we are going to send the data
$DataSet = Get-PBIDataSet -authToken $authToken -Name "Environment Sensors"
# Update the PowerBI Dataset with the latest readings.
$outsideEnvData | Out-PowerBI -AuthToken $authToken -dataSetName $DataSet.name -tableName "Outside" -verbose
$insideEnvData | Out-PowerBI -AuthToken $authToken -dataSetName $DataSet.name -tableName "Inside" -verbose
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.