> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/1.-create-bridge.md).

# Create a bridge to integrate and transform plans

A bridge provides a unified workspace for integrating data sources such as planning sheets, PowerTable sheets, or file-based sources. Use the bridge editor to transform and prepare data for planning. Bridges support data consolidation, real-time planning, and collaboration.

### Create a bridge <a href="#create-a-bridge" id="create-a-bridge"></a>

Consolidate planning sheets across dimensions with varying granularities using bridges.

1. To create a bridge, in the **Infobridge** ribbon, select **Create Query**.

2. Select the measures to consolidate in the bridge, then select **Create**.<br>

   <figure><img src="/files/zn2oKoQIrs6Nuf8Lm0wo" alt=""><figcaption></figcaption></figure>

3. Creating a query automatically opens Infobridge, where you can join, append, merge, pivot, and transform data. Select **Close** to return to the planning sheet.<br>

   <figure><img src="/files/5B1Pqv4gN8I3z2muHsO9" alt=""><figcaption></figcaption></figure>

4. To access the bridge from a planning sheet, from the **Data** pane, expand **Queries**. Select **More options (…)** > **Edit** to open Infobridge. You can also delete or rename the query.<br>

   <figure><img src="/files/fklLVh0wgE0ksbf0CtmA" alt=""><figcaption></figcaption></figure>

5. Repeat the same process to add measures from other planning sheets to the bridge.<br>

   <figure><img src="/files/fsj8TArJdxrBSfMJ7dnS" alt=""><figcaption></figcaption></figure>

   \
   This example consolidates the bonus component across roles and departments in the bridge.\ <br>

   <figure><img src="/files/UAMNgxfejXgsytDhXldc" alt=""><figcaption></figcaption></figure>

6. Within Infobridge, hover over the query name and select **More options (…)** to edit, delete, duplicate, rerun the job, or copy the query ID.\ <br>

   <figure><img src="/files/mnVRVaowH3H9P2nNdyyd" alt=""><figcaption></figcaption></figure>

### Import data into a bridge <a href="#import-data-into-a-bridge" id="import-data-into-a-bridge"></a>

Infobridge supports data integration to centralize data for analysis and reporting. Import and consolidate data from planning sheets, PowerTable sheets, and CSV, Excel, JSON, and Parquet files into a unified planning model.

1. Select **Add Source** and choose the source type.<br>

   <figure><img src="/files/8CqKxpvaXee4QWMdUKcD" alt=""><figcaption></figcaption></figure>

2. For file-based sources, select and upload the file.<br>

   <figure><img src="/files/PyErcKjD7jpVirsN189R" alt=""><figcaption></figcaption></figure>

3. Infobridge adds a new query that holds the source data to the bridge.\ <br>

   <figure><img src="/files/b0fgicceaVBpjIZzv13K" alt=""><figcaption></figcaption></figure>

To use data from the query in a planning sheet, import dimensions and measures from the **Queries** section of the **Data** pane.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/documentation/plan/infobridge/how-tos/1.-create-bridge.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
