| pbi_push_rows {powerbiR} | R Documentation |
Push rows to a dataset table
Description
Adds new data rows to the specified table within the specified dataset from the specified Power BI workspace. Only applicable to push datasets.
Usage
pbi_push_rows(dt, group_id, dataset_id, table_name, overwrite = FALSE)
Arguments
dt |
A data frame with rows to be added to the specified Power BI table (table_name). The columns and data types must match the specified table. |
group_id |
The ID of the destination Power BI workspace. |
dataset_id |
The ID of the destination Power BI dataset. |
table_name |
The name of the destination Power BI table. |
overwrite |
If TRUE, existing rows will be deleted prior to adding new rows. If FALSE, the new rows will be appended to the existing rows. |
Details
The Power BI REST has a limit of 10K rows per POST rows request. This limit is handled by splitting the data frame into chunks of 10K rows each and pushing these chunks one at a time. However, you should manually observe the other limitations of the API. See https://docs.microsoft.com/en-au/rest/api/power-bi/ for more details.
Value
A dataset with tables and optionally defined relationships will be created in the specified Power BI workspace.
Examples
## Not run:
group_id <- "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
dataset_id <- "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
pbi_push_rows(group_id, dataset_id, "My table")
## End(Not run)