Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Create Attribute History Power BI Dataset
$dataSetSchema = @{
name = "EmployeeEndDateReport"
defaultMode = "PushStreaming"
; tables = @(
@{name = "Employee"
; columns = @(
,@{ name = "Date"; dataType = "dateTime" }
, @{ name = "AccountName"; dataType = "string" }
, @{ name = "DisplayName"; dataType = "string" }
, @{ name = "Active"; dataType = "Boolean" }
, @{ name = "EndDate"; dataType = "dateTime" }
, @{ name = "EndDateReceived"; dataType = "dateTime" }
)}
)}
$dataSetMetadata = New-PBIDataSet -authToken $authToken -dataSet $dataSetSchema -defaultRetentionPolicy BasicFIFO -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.