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.

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: To see the workspace options you have to be authenticated.

Create new Dataset

Select this option to create a new dataset in the selected Power BI workspace.

Select existing Dataset

Select this option to append the input tables to an existing dataset or to overwrite all rows of a table of an existing dataset. Note that the dataset has to be a "Push dataset" for this option to work.

Dataset name

The name of the dataset to create.

Table name

The name of the table in the dataset to upload. If multiple tables are uploaded a name has to be configured for each table and the names have to be unique.

Delete and create new if dataset exists

Select this option to delete a dataset with the same name if one exists before creating the new dataset. If a dataset with the configured name exists but this option is not selected the node will fail.
NOTE: All reports and dashboard tiles containing data from the dataset will also be deleted.

Append/Overwrite rows

Select if the input tables should be appended to the existing tables or if all rows of the exiting table should be deleted and overwritten by the input rows.

Relationships

Add relationship

The node can define an arbitrary number of relationships. Click this button to define a new relationship between two columns.

From

Each relationship is defined between a source column and a target column. Note that the columns must be located in different input tables. Select an input table and the column that serves as source column here.

To

Select a table and column that serves as the relationship's target column.

Cross filtering

Each relationship defines how filters set on involved columns propagate. If "One direction" is selected, filters will be applied to the table where values are aggregated. If "Both directions" is selected, filtering is applied as if both tables were joined into a single table. To let Power BI figure out a sensible configuration, select "Automatic". For further information, check out the Power BI documentation.

Views

This node has no views

Workflows

• 08_BIRT_Example_AdvancedKNIME Hub
• Advanced Web Scraper for H&MKNIME Hub
• Contineo_Labs_Data_ChallengeKNIME Hub
• CSV-Power BIKNIME Hub
• Date Table GeneratorKNIME Hub
• Show all 22 workflows

Links

• No links available

Developers