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