> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# PowerBIWrite

> Send your pipeline output directly to PowerBI

export const execution_engine_0 = "Prophecy Automate"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

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.

## 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](/data-analysis/environment/connections/power-bi) to use for the gem.                                                                                                                                   |
| Workspace Name                     | Power BI [workspace](https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces) that contains or will contain the dataset.                                                                         |
| Create New or Use Existing Dataset | Choose **Dataset Name** to create a new dataset in the workspace. <br />Choose **Dataset ID** to push tables to an existing dataset in the workspace. <br />These options are described in detail in the following sections. |

<Info>
  **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](https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-rename).
</Info>

### 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.<br />Choose **Append** when you want to preserve existing data and continuously add new entries. <br />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. <br />Choose **Yes** if you expect the schema to evolve and want Power BI to reflect those changes automatically. <br />Choose **No** to preserve the current schema in Power BI, even if the incoming data has a different structure. |