Send to Power BI (chunked)

WARNING: The execution of this component may take several hours.

Send a table to Power BI that has more than 1Mio rows. Power BI only allows to upload 1Mio rows to a single dataset per hour. Therefore, this component waits for a specified amount of time (usually 65min) between uploading a specified amount of rows (usually 1Mio) to Power BI.

Options

Rows per chunk (default: 1M)

Number of rows to upload per chunk. The Power BI REST API allows to upload 1M rows per hour per dataset. Therefore 1M is a good choise for this number.

Waiting time (min)

Minutes to wait between uploads.

Dataset name

The name of the dataset to create.

Table name

The name of the table in the dataset to upload.

Nodes

• Integer Configuration2 ×
• Send to Power BI2 ×
• String Configuration2 ×
• Variable Creator2 ×
• Catch Errors (Var Ports)1 ×
• Show all 15 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Power BI Integration
• FeatureKNIME Quick Forms

Links

• No links available