Push rows to Dataset Table

Documentation

Push table rows to dataset table.

Rows can be pushed to tables in a dataset if they match the table’s schema (column names and types) and satisfy other requirements and limitations for pushing data:

• The dataset must be a push dataset.

• The amount of data and the number of requests are limited, for example, 1,000,000 rows added per hour per dataset and 4,000 characters per value for string column.

• See API limitations for more details.

Push datasets can be created using Create Dataset.

Has an optional PowerBi output

Definition

Input ports

powerbi powerbi

PowerBi

table table

Table

Output ports

powerbi 0 - 1, powerbi

PowerBi

Configuration

Rate of requests per hour (rate)

Set the rate of requests per hour to comply with the limits: 120 POST requests per minute (7200 per hour), used for dataset tables with less than 250,000 rows (always the case for FIFO). 120 POST requests per hour used for tables with 250,000 or more rows.

Table (table)

Choose output table name in the active Dataset, required.

When tables are missing: ensure the previous node is executed and sets active Dataset or type an existing table name.

Examples

• BasicPowerBI.syx

Implementation

class node_powerbi.PushTableRowsPowerBi