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 |
|
||||||
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