Add-PowerBIRow

NAME Add-PowerBIRow



SYNOPSIS

Adds rows to the specified table in a Power BI dataset.





SYNTAX

Add-PowerBIRow -Dataset <Dataset> -Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]>

-TableName <String> [-Workspace <Workspace>] [-WorkspaceId <Guid>] [<CommonParameters>]



Add-PowerBIRow -DatasetId <Guid> -Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]>

-TableName <String> [-Workspace <Workspace>] [-WorkspaceId <Guid>] [<CommonParameters>]





DESCRIPTION

Inserts rows into a Power BI table contained within a dataset.





PARAMETERS

-Dataset <Dataset>

A dataset containing the table where rows are to be stored.



Required? true

Position? named

Default value None

Accept pipeline input? True (ByValue)

Accept wildcard characters? false



-DatasetId <Guid>

ID of the dataset containing the table where rows are to be stored.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]>

An array of rows to be stored in the table.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-TableName <String>

Name of the table.



Required? true

Position? named

Default value None

Accept pipeline input? False

Accept wildcard characters? false



-Workspace <Workspace>

Workspace containing the dataset and table for row insertion.



Required? false

Position? named

Default value None

Accept pipeline input? True (ByValue)

Accept wildcard characters? false



-WorkspaceId <Guid>

ID of the workspace containing the dataset and table for row insertion.



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.Datasets.Dataset

Microsoft.PowerBI.Common.Api.Workspaces.Workspace





OUTPUTS

Microsoft.PowerBI.Common.Api.Datasets.Dataset







NOTES









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



PS C:\\>Add-PowerBIRow -DataSetId 4b644350-f745-48dd-821c-f008350199a8 -TableName Table1 -Rows

@{"Column1"="Value1";"Column2"="Value2"},@{"Column1"="Value1";"Column2"="Value2"}



This example inserts two rows to Table1.

-------------------------- Example 2 --------------------------



PS C:\\>Add-PowerBIRow -DataSetId 4b644350-f745-48dd-821c-f008350199a8 -TableName Table1 -Rows (Import-Csv -Path

".\\data.csv")



This example inserts rows from CSV to Table1.



RELATED LINKS