< Back

New-PowerBIColumn

Sat Jan 18, 2020 4:13 pm

NAME New-PowerBIColumn



SYNOPSIS

Creates a new Power BI column object.





SYNTAX

New-PowerBIColumn -DataType {Int64 | Double | Boolean | DateTime | String} -Name <String> [<CommonParameters>]





DESCRIPTION

Initiates the creation of a new Power BI column object. Columns are building blocks for constructing a table

object.





PARAMETERS

-DataType <PowerBIDataType>

A type of the column.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Name <String>

A column name.



Required? true

Position? named

Default value None

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

Microsoft.PowerBI.Common.Api.Datasets.Column







NOTES









-------------------------- Example 1 --------------------------



PS C:\\>$col1 = New-PowerBIColumn -Name ID -DataType Int64

PS C:\\>$col2 = New-PowerBIColumn -Name Data -DataType String

PS C:\\>$table1 = New-PowerBITable -Name SampleTable1 -Columns $col1,$col2

PS C:\\>

PS C:\\>$col3 = New-PowerBIColumn -Name ID -DataType Int64

PS C:\\>$col4 = New-PowerBIColumn -Name Date -DataType DateTime

PS C:\\>$col5 = New-PowerBIColumn -Name Detail -DataType String

PS C:\\>$col6 = New-PowerBIColumn -Name Result -DataType Double

PS C:\\>$table2 = New-PowerBITable -Name SampleTable2 -Columns $col3,$col4,$col5,$col6

PS C:\\>

PS C:\\>$dataset = New-PowerBIDataSet -Name SampleDataSet -Tables $table1,$table2

PS C:\\>

PS C:\\>Add-PowerBIDataSet -DataSet $dataset



This example instantiates a table with two columns and another table with four columns, and instantiates a

dataset. Then, it creates the dataset in Power BI.



RELATED LINKS