PowerBI Load

With this load type, data can be written into Push Datasets in Microsoft Power BI. Jedox PowerBI load uses Push Datasets from the Power BI REST API and requires a Jedox Power BI Connector License and Power BI Connection.

Note: according to Microsoft's deprecation announcement, real-time streaming (including push semantic models) in Power BI will no longer be supported as of October 31, 2027.

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. Any existing dataset and table are removed.
Update Any existing data will be cleared from the table, and new data is loaded. Note that the dataset and table must already exist.
Insert Data will be inserted into the table. Note that the dataset and table must already exist.
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".

Additional information: Real-Time Streaming in Power BI (Microsoft article)

Updated February 7, 2025