Add-PowerBIRow
Adds rows to the specified table in a Power BI dataset.
Syntax
Add-PowerBIRow
-Dataset <Dataset>
-TableName <String>
-Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]>
[-WorkspaceId <Guid>]
[-Workspace <Workspace>]
[<CommonParameters>]
Add-PowerBIRow
-DatasetId <Guid>
-TableName <String>
-Rows <System.Collections.Generic.List`1[System.Management.Automation.PSObject]>
[-WorkspaceId <Guid>]
[-Workspace <Workspace>]
[<CommonParameters>]
Description
Inserts rows into a Power BI table contained within a dataset.
Examples
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.
Parameters
-Dataset
A dataset containing the table where rows are to be stored.
Type: | Dataset |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-DatasetId
ID of the dataset containing the table where rows are to be stored.
Type: | Guid |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Rows
An array of rows to be stored in the table.
Type: | System.Collections.Generic.List`1[System.Management.Automation.PSObject] |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-TableName
Name of the table.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Workspace
Workspace containing the dataset and table for row insertion.
Type: | Workspace |
Aliases: | Group |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-WorkspaceId
ID of the workspace containing the dataset and table for row insertion.
Type: | Guid |
Aliases: | GroupId |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Inputs
Microsoft.PowerBI.Common.Api.Datasets.Dataset
Microsoft.PowerBI.Common.Api.Workspaces.Workspace
Outputs
Microsoft.PowerBI.Common.Api.Datasets.Dataset
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για