PowerBI Load

With this load type, data can be written into datasets in the business analytics service Power BI, provided by Microsoft.

Jedox PowerBI load uses the Power BI REST API (https://docs.microsoft.com/en-us/rest/api/power-bi).

Datasets and tables that do not exist are created in Power BI.

Data can only be loaded into datasets created by means of Power BI REST API.

For this load, a Power BI Connector License and an Integrator connection to Power BI is required.

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.

Note: All Date columns (with column types java.sql.Date, java.util.Date, java.sql.Timestamp) will be displayed in the format "yyyy-MM-dd hh:mm:ss" in Power BI. Columns with format java.sql.Time will be displayed in the format of "hh:mm:ss".

Updated January 29, 2024