PowerBIWrite
The PowerBIWrite gem lets you publish pipeline results directly to Power BI tables. This gem supports fine-grained options like write modes and schema management to control how tables are written. You can configure the gem to either write tables to new datasets or existing ones in a specified Power BI workspace.
Datasets in the PowerBIWrite gem refer to the semantic model content type in Power BI. For more information, visit New name for Power BI datasets.
Inputs
The PowerBIWrite gem accepts the following inputs.
| Port | Description |
|---|---|
| in0 | Table to add or update in the dataset. |
| inN | Additional table to add or update in the dataset. |
To add additional input ports, click + next to Ports.
Parameters
Use the following parameters to configure the PowerBIWrite gem.
| Parameter | Description |
|---|---|
| Select or create connection | Power BI connection to use for the gem. |
| Workspace Name | Power BI workspace that contains or will contain the dataset. |
| Create New or Use Existing Dataset | Choose Dataset Name to create a new dataset in the workspace. Choose Dataset ID to push tables to an existing dataset in the workspace. These options are described in detail in the following sections. |
Dataset Name
Select this option to create a new dataset in your workspace. You will need to give the dataset a name that will appear in Power BI.
Table Write Configuration
This configuration lets you define how your table(s) will be written to the dataset. Each row accepts the following parameters:
| Parameter | Description |
|---|---|
| Input Alias | Input port that maps to a table in Power BI. Example: in0, in1 |
| Table Name | Write a corresponding table name that will appear in Power BI. |
Dataset ID
Select this option to update table inside an existing dataset in your workspace. You will need the Dataset ID to identify the existing dataset. The Dataset ID is typically part of the URL when you open a dataset in Power BI.
Table Write Configuration
This configuration lets you define how your table(s) will be written to the dataset. Each row accepts the following parameters:
| Parameter | Description |
|---|---|
| Input Alias | Input port that maps to a table in Power BI. Example: in0, in1 |
| Table Name | Write a corresponding table name that will appear in Power BI. |
| Write Mode | Controls how data is written to the Power BI table. Choose Append when you want to preserve existing data and continuously add new entries. Choose Overwrite if you want to fully refresh the table in Power BI. |
| Overwrite Schema | Determines whether the schema (columns and their types) in Power BI should be replaced when it differs from the incoming dataset. Choose Yes if you expect the schema to evolve and want Power BI to reflect those changes automatically. Choose No to preserve the current schema in Power BI, even if the incoming data has a different structure. |