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 Integer), Number (Float), Boolean, Date, and Date&Time (Local).

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.

Options

Workspace

Select the workspace to use. Select "default" to use the default workspace which is called "My workspace" in the Power BI user interface.
NOTE: Authenticate using the Microsoft Authenticator node to see available workspaces.

Dataset mode

Choose whether to create a new dataset or select an existing one. When selecting an existing dataset, you can append rows to existing tables or overwrite all rows.
Note: Only "Push datasets" (datasets that support streaming or programmatic data upload) can be selected. Regular Power BI datasets are not supported.

Dataset name

The name of the dataset to create in the workspace.

Table name

The name of the table(s) in the dataset to upload. Each table must have a unique name.

Delete and recreate if exists

If enabled, deletes a dataset with the same name before creating a new one. If disabled and a dataset with the configured name already exists, the node will fail.
WARNING: Deleting a dataset will permanently remove it along with ALL associated reports and dashboard tiles. This action cannot be undone.

Table operation

Select whether to append new rows to existing tables or replace all rows with the input data. Overwriting will delete all current data in the selected tables.

Relationships

Define relationships between tables to enable cross-table filtering in Power BI. Each relationship connects a column from one table (source) to a column in another table (target). Columns must be in different input tables and typically share common values (e.g., foreign keys).

• From table: Select the table that contains the source column.
• From column: Select the column that serves as the source column.
• To table: Select the table that contains the target column.
• To column: Select the column that serves as the target column.
• Cross filtering: Control how filters propagate across related tables.
  • Automatic: Let Power BI determine the best filtering behavior
  • One direction: Filters will be applied to the table where values are aggregated
  • Both directions: Filtering is applied as if both tables were joined into a single table

Views

This node has no views

Workflows

• 03 Microsoft Fabric Integration OverviewKNIME Hub
• 08_BIRT_Example_AdvancedKNIME Hub
• 2. Export to PowerBIKNIME Hub
• AI_Fraud_DetectionKNIME Hub
• AI_Fraud_DetectionKNIME Hub
• Show all 45 workflows

Links

• No links available

Developers