PowerBI Load

image_pdfimage_print

With this load type, data can be written into datasets in the business analytics service Power BI, provided by Microsoft. Datasets and tables that do not exist are created in Power BI. For this load, a Power BI Connector License and an Integrator connection to Power BI is required.

Main settings

Data source

Extract or transform containing the data to be written.

Tree format

If the data source is a tree, the hierarchy format must be entered. See Overview of Tree Formats.

Target connection

A connection of type PowerBI.

Mode

  • Create: a new dataset and a new table is created. An existing dataset and table is removed.
  • Update: if the dataset does not exist, it will be created along with the table. If the dataset does exist, the table must also exist. Existing data will be cleared from the table, new data is loaded.
  • Insert: if the dataset does not exist, it will be created along with the table. If the dataset does exist, the table also must exist. Data will be inserted into the table.

Dataset

An Integrator dataset.

Table

The target table to which the data will be loaded.
image_pdfimage_print