Add-PowerBIDataset

NAME Add-PowerBIDataset



SYNOPSIS

Adds a dataset to a Power BI workspace.





SYNTAX

Add-PowerBIDataset -Dataset <Dataset> -Workspace <Workspace> [<CommonParameters>]



Add-PowerBIDataset -Dataset <Dataset> [-WorkspaceId <Guid>] [<CommonParameters>]





DESCRIPTION

Publishes a dataset to Power BI service under a workspace.





PARAMETERS

-Dataset <Dataset>

The dataset to be added.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Workspace <Workspace>

Workspace to add the dataset. If not specified, the dataset will reside under "My Workspace".



Required? true

Position? named

Default value None

Accept pipeline input? True (ByValue)

Accept wildcard characters? false



-WorkspaceId <Guid>

ID of the workspace to add the dataset. If not specified, the dataset will reside under "My Workspace".



Required? false

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

Microsoft.PowerBI.Common.Api.Workspaces.Workspace







OUTPUTS

Microsoft.PowerBI.Common.Api.Datasets.Dataset







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 under "My Workspace".



RELATED LINKS