Send to Power BI

This node sends the input table to Microsoft Power BI.

The node only uploads columns that are supported by Power BI. Other columns are ignored. The supported types are String, Number (integer), Number (long), Number (double), Boolean value, Local Date, and Local Date Time. The node uploads rows in chunks to Microsoft Power BI. If the node is canceled, the already uploaded rows will remain in the Power BI dataset. Use the "Microsoft Authenticator" node to connect to your Microsoft account. The KNIME Analytics Platform Azure Application needs the following permissions for this node:

• View all datasets : Needed to check if a dataset already exists in your Power BI workspace.
• Read and write all datasets : Needed to upload a table to a Power BI dataset in your workspace.
• View all workspaces : Needed to get the identifier of the selected Power BI workspace.
• Maintain access to data you have given it access to : Needed to access the Power BI API during the node execution without asking you to log in again.

Note: The Power BI REST API has some limitations in terms of the size of a dataset and the number of rows that can be shipped per hour. For more information visit the documentation.

Input ports

1. Type: org.knime.credentials.base.CredentialPortObject
   Credential (JWT)
   A JWT credential as provided by the Microsoft Authenticator node.
2. Type: Table
   Table
   Data to be send to Power BI.

input (Dynamic Inport)

Additional data to be send to your data set.

1. Type: Table