Out-PowerBI

NAME Out-PowerBI



SYNOPSIS

A one line cmdlet that you can use to send data into PowerBI





SYNTAX

Out-PowerBI -Data <Object> [-AuthToken <String>] [-DataSetName <String>] [-TableName <String>] [-BatchSize

<Int32>] [-MultipleTables] [-ForceAskCredentials] [-ForceTableSchemaUpdate] [-Types <Hashtable>] [-groupId

<String>] [<CommonParameters>]



Out-PowerBI -Data <Object> -Credential <Object> [-DataSetName <String>] [-TableName <String>] [-BatchSize <Int32>]

[-MultipleTables] [-ForceAskCredentials] [-ForceTableSchemaUpdate] [-Types <Hashtable>] [-groupId <String>]

[<CommonParameters>]





DESCRIPTION





PARAMETERS

-Data <Object>

The data that will be sent to PowerBI



Required? true

Position? named

Default value

Accept pipeline input? true (ByValue)

Accept wildcard characters? false



-AuthToken <String>

The AccessToken - Optional



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Credential <Object>

specifies a PSCredential object used to authenticate to the PowerBI service. This is used to automate the

sign in process so you aren't prompted to enter a username and password in the GUI.



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DataSetName <String>

The name of the dataset - Optional, by default will always create a new dataset with a timestamp



Required? false

Position? named

Default value ("PowerBIPS_{0:yyyyMMdd_HHmmss}" -f (Get-Date))

Accept pipeline input? false

Accept wildcard characters? false



-TableName <String>

The name of the table in the DataSet - Optional, by default will be named "Table"



Required? false

Position? named

Default value Table

Accept pipeline input? false

Accept wildcard characters? false



-BatchSize <Int32>

The size of the batch that is sent to PowerBI as HttpPost.



If for example the batch size is 100 and a collection of

1000 rows are being pushed then this cmdlet will make 10

HttpPosts



Required? false

Position? named

Default value 1000

Accept pipeline input? false

Accept wildcard characters? false



-MultipleTables [<SwitchParameter>]

A indication that the hashtable passed is a multitable



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ForceAskCredentials [<SwitchParameter>]



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ForceTableSchemaUpdate [<SwitchParameter>]



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-Types <Hashtable>



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-groupId <String>

Id of the workspace where the reports will get pulled



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Get-Process | Out-PowerBI -clientId "7a7be4f7-c64d-41da-94db-7fb8200f029c"



1..53 |% {

@{

Id = $_

; Name = "Record $_"

; Date = [datetime]::Now

; Value = (Get-Random -Minimum 10 -Maximum 1000)

}

} | Out-PowerBI -clientId "7a7be4f7-c64d-41da-94db-7fb8200f029c" -verbose











RELATED LINKS