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

# Microsoft Fabric

> You can connect Microsoft Fabric to Connect AI with the Connect AI plugin.

## Prerequisites

Before you connect, you must first connect a data source to your Connect AI account. See [Sources](/en/Sources) for more information.

## Connect to Connect AI

To establish a connection from Microsoft Fabric to Connect AI, follow these steps.

<Steps>
  <Step>
    Log in to Microsoft Fabric.
  </Step>

  <Step>
    In Microsoft Fabric, select a workspace in which to create the flow, or create a new workspace.
  </Step>

  <Step>
    Click **New item** and then click **Dataflow Gen2**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_new_item.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=70f16b60c8a3a4a48f1c21d48ab4d2c5" alt="Fabric Client New Item" width="1401" height="643" data-path="en/images/fabric_client_new_item.png" />
    </Frame>
  </Step>

  <Step>
    Once inside the data flow, click **Get Data**. Enter *Connect AI* in the search bar and select the **Connect AI** plugin.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_choose_data.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=9ce84938d443fa4647d22cfa683eb05f" alt="Fabric Client Choose Data" width="904" height="446" data-path="en/images/fabric_client_choose_data.png" />
    </Frame>
  </Step>

  <Step>
    In the **Get data** dialog, enter the following credentials:

    * **Connection**—select **Create new connection**.
    * **Connection name**—create a user-defined connection name.
    * **Data gateway**—select **(none)**.
    * **Authentication kind**—select **CData Connect account**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_sign_in.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=80197313f1922a7683a9ce5543c810bc" alt="Fabric Client Sign In" width="741" height="413" data-path="en/images/fabric_client_sign_in.png" />
    </Frame>
  </Step>

  <Step>
    Click **Sign in**. You are redirected to our authentication page via OAuth, establishing a connection to Connect AI.
  </Step>

  <Step>
    Click **Next**. All your connections, derived views, and workspaces are now visible.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_connections.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=4d626cf36525c26d0195abd262e3816f" alt="Fabric Client Connections" width="1119" height="500" data-path="en/images/fabric_client_connections.png" />
    </Frame>
  </Step>

  <Step>
    Select a table in your connection/schema hierarchy to load the desired table.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_load_table.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=af267d7338f456b66f59be1d816c40cf" alt="Fabric Client Load Table" width="1329" height="649" data-path="en/images/fabric_client_load_table.png" />
    </Frame>
  </Step>

  <Step>
    Click **Create** to launch the **Power Query** page.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_power_query.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=a2a4398ffc257ada84039a71c7422220" alt="Fabric Client Power Query" width="1326" height="657" data-path="en/images/fabric_client_power_query.png" />
    </Frame>
  </Step>

  <Step>
    To replicate your data to a destination, click **+** next to **Data destination**. A **Connect to data destination** dialog appears. In this example, we used SQL Server as a destination. Enter the destination settings and click **Next**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_data_destination.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=66872a93221aefcb9e908e0a06a6a159" alt="Fabric Client Data Destination" width="1312" height="629" data-path="en/images/fabric_client_data_destination.png" />
    </Frame>
  </Step>

  <Step>
    Select a destination target. You can overwrite an existing table or create a new destination table. Click **Next**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_destination_target.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=0bdcba55480c91c17527f33cad8bad6d" alt="Fabric Client Destination Target" width="1331" height="622" data-path="en/images/fabric_client_destination_target.png" />
    </Frame>
  </Step>

  <Step>
    Map the data types for your destinations. Click **Save settings**.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_destination_settings.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=915a4d805528db844397908e7424ae2e" alt="Fabric Client Destination Settings" width="1323" height="621" data-path="en/images/fabric_client_destination_settings.png" />
    </Frame>
  </Step>

  <Step>
    When you run/refresh the data flow, your table is copied to the selected destination. You can also modify the content in the Power Query editor.

    <Frame>
      <img src="https://mintcdn.com/cdata/TyMUmkWaSd5jpB6P/en/images/fabric_client_query_editor.png?fit=max&auto=format&n=TyMUmkWaSd5jpB6P&q=85&s=12e9af0ccc19068cbd9f79cb31ef18fd" alt="Fabric Client Query Editor" width="1329" height="593" data-path="en/images/fabric_client_query_editor.png" />
    </Frame>
  </Step>
</Steps>