Skip to content

Instantly share code, notes, and snippets.

@darrenjrobinson
Last active November 13, 2017 19:30
Show Gist options
  • Save darrenjrobinson/774981eaa4df0cdaf9b876d491acd48c to your computer and use it in GitHub Desktop.
Save darrenjrobinson/774981eaa4df0cdaf9b876d491acd48c to your computer and use it in GitHub Desktop.
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