> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-bradley-turek-pfilter-operators-reference.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Power BI AAD Writeback Connector

## Intro

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. With Domo's Power BI AAD Writeback connector, you can transfer your data from a Domo dataset to your Power BI dataset. To learn more about the Power BI API, visit their page ([https://docs.microsoft.com/en-us/rest/api/power-bi/)](https://docs.microsoft.com/en-us/rest/api/power-bi/)).

You configure your Power BI AAD account in the Data Center. This topic discusses the fields and menus that are specific to the Power BI AAD Writeback connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Connector](/s/article/360063090013).

<Note>**Note:** The owner of a writeback dataset must also be an owner or co-owner of the input dataset.</Note>

***

## Prerequisites

To configure this connector, you must have the following:

* An installed Microsoft Azure app.
* The Client ID and Client Secret for your Azure app.
* The Tenant ID for your Azure app. This is generated when you create your Azure app.

#### **To obtain the Azure App Client ID**:

1. Go to [https://portal.azure.com](https://portal.azure.com/).

2. Select Microsoft Entra ID > Under Manage > Select App registrations.

3. Find and click on your web app.

4. The "application ID" is your **Client ID**.

<Frame>
  <img src="https://mintcdn.com/domoinc-bradley-turek-pfilter-operators-reference/QEKgHKuT7p4sY7Jc/images/kb/0EMVq00000AEULR.jpg?fit=max&auto=format&n=QEKgHKuT7p4sY7Jc&q=85&s=8567059668cd9aa4e1d0a49417be0b39" alt="Screenshot" width="895" height="651" data-path="images/kb/0EMVq00000AEULR.jpg" />
</Frame>

#### **To obtain a new Azure App Client secret**:

1. Go to [https://portal.azure.com](https://portal.azure.com/).

2. Select Microsoft Entra ID > Under Manage > Select App registrations.

3. Find and click on your web app.

4. Under Manage > Certificates & secrets.

5. Click **+New client secret**.

6. Provide the client secret description and the expiry period for your secret. Click **Add**.

7. Your new client secret will appear. Copy it and paste in your Domo connector Client Secret field.

<Frame>
  <img src="https://mintcdn.com/domoinc-bradley-turek-pfilter-operators-reference/QEKgHKuT7p4sY7Jc/images/kb/0EMVq00000AEUbZ.jpg?fit=max&auto=format&n=QEKgHKuT7p4sY7Jc&q=85&s=16d02b2502003d81861cbc7b9208ec63" alt="Screenshot" width="1420" height="650" data-path="images/kb/0EMVq00000AEUbZ.jpg" />
</Frame>

#### **To obtain the Tenant ID**:

1. Login to the Azure Portal ([https://portal.azure.com](https://portal.azure.com)).

2. Navigate to Microsoft Entra ID >> Under Manage >> Properties.

3. Copy the Tenant ID.

<Frame>
  <img src="https://mintcdn.com/domoinc-bradley-turek-pfilter-operators-reference/QEKgHKuT7p4sY7Jc/images/kb/0EMVq00000AIdDF.jpg?fit=max&auto=format&n=QEKgHKuT7p4sY7Jc&q=85&s=b20641a7da6d9988f3adb3eb730a9ec4" alt="Screenshot" width="1207" height="976" data-path="images/kb/0EMVq00000AIdDF.jpg" />
</Frame>

### Creating an Azure App for Enterprise OAuth

To create a Microsoft Azure app, do the following:

1. Log into [https://portal.azure.com](https://portal.azure.com/).

2. Click on **App registrations**.

3. Click **New registration**.

4. Enter the application name and select the supported account type as below. Enter the Redirect URI for Web as **[https://oauth.domo.com/api/data/v1/oauth/providers/power-bi-writeback-aad/exchange](https://oauth.domo.com/api/data/v1/oauth/providers/power-bi-writeback-aad/exchange)**

5. Click **Register**. Once the application is registered, you can view the Client ID (application ID), client secret, and tenant ID.

6. Once the application is registered, assign the required API permissions for your application.

7. Click **API Permissions > +Add a permission**.

8. Request API Permissions page will appear displaying the commonly used APIs.

9. Select the API, and add the Delegated and Application permissions.

10. Click on **Grant admin consent**, then click **Yes** to allow the admin consent for your permissions.The added permissions will appear in the **Configured permissions** section with their details.

11. Now, click on **Certificates & Secrets**. Certificates can be used as secrets to prove the application's identity when requesting a token. Also, can be referred to as public keys.

12. Click on **+ New Client Secret** button.

13. Specify the client secret description and the expiry period for your client secret, and click **Add**.

14. Copy the **value** and paste it into the **Client Secret** field in the Connector credentials section in Domo.

<Frame>
  <img src="https://mintcdn.com/domoinc-bradley-turek-pfilter-operators-reference/QEKgHKuT7p4sY7Jc/images/kb/0EMVq00000AEUEz.jpg?fit=max&auto=format&n=QEKgHKuT7p4sY7Jc&q=85&s=213f3fbd74c4f26851f2d8cf53bfb458" alt="Screenshot" width="1420" height="650" data-path="images/kb/0EMVq00000AEUEz.jpg" />
</Frame>

<Note>**Note:** Ensure to copy the Value and *not* the Secret ID.</Note>

### Enabling the 'Allow public client flows'

1. Go to [https://portal.azure.com](https://portal.azure.com/).

2. Select Microsoft Entra ID > Under Manage > Select App registrations.

3. Find and click on your web app.

4. Click on **Authentication**.

5. Enable the following mobile and desktop flows by selecting **YES**.

### Granting Admin consent in App registration

1. Go to [https://portal.azure.com](https://portal.azure.com/).

2. Select Microsoft Entra ID > Under Manage > Select App registrations.

3. Find and click on your web app that you want to enable the admin consent for.

4. Select API permissions.

5. Review the permissions that the application requires. If you agree, select **Grant admin consent**.

<Frame>
  <img src="https://mintcdn.com/domoinc-bradley-turek-pfilter-operators-reference/QEKgHKuT7p4sY7Jc/images/kb/0EMVq00000AETPN.jpg?fit=max&auto=format&n=QEKgHKuT7p4sY7Jc&q=85&s=875c33b092d1dcfd6843af14ad64d4ce" alt="API Permissions" width="1365" height="566" data-path="images/kb/0EMVq00000AETPN.jpg" />
</Frame>

## Configuring the Connection

This section enumerates the options in the **Credentials** and **Details** panes in the Power BI AAD Writeback Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most Connector types and are discussed in great detail in [Adding a DataSet Using a Connector](/s/article/360042926274).

### Credentials Pane

This pane contains fields for entering credentials to connect to your Power BI account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1">
  <thead>
    <tr>
      <th colspan="1" rowspan="1"><p>Field</p></th>
      <th colspan="1" rowspan="1"><p>Description</p></th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td colspan="1" rowspan="1"><p>Azure App Client ID</p></td>
      <td colspan="1" rowspan="1"><p>Enter the client ID of the client web app obtained from Azure Active Directory configuration. For more information, see "Obtaining the Azure App Client ID".</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>Azure App Client Secret</p></td>
      <td colspan="1" rowspan="1"><p>Enter the secret key of the client web app. For more information, see "Obtaining the Azure App Client Secret".</p></td>
    </tr>

    <tr>
      <td colspan="1" rowspan="1"><p>Azure Tenant ID</p></td>
      <td colspan="1" rowspan="1"><p>Enter your Tenant ID. For more information, see "Obtaining the Tenant ID".</p></td>
    </tr>
  </tbody>
</table>

For more information about obtaining these credentials, see Prerequisites, above.

Once you have entered valid Power BI credentials, you can use the same account any time you go to set up a new Domo-Power BI connection. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector Accounts](/s/article/360042926054).

### Details Pane

This pane contains a number of fields for specifying your data and indicating where it's going.

| Menu                              | Description                                                                                                                                                                                                                                                                                                                       |
| --------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Domo Input DataSet Id             | Enter your Domo dataset ID(GUID) located in the dataset URL. For example: [https://customer.domo.com/datasources/](https://customer.domo.com/datasources/)<strong>aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee</strong>/details/settings                                                                                                  |
| Select Group                      | Select the group (The workspace ID).                                                                                                                                                                                                                                                                                              |
| Enter Dataset Name                | Enter the dataset name in the specified group (workspace).                                                                                                                                                                                                                                                                        |
| Enter Table Name                  | Enter the table name to update the metadata and schema for the specified table in the dataset from My workspace.                                                                                                                                                                                                                  |
| Cast Decimal to Double (checkbox) | Select this checkbox to convert the **Decimal** column from the input dataset to **Double** in Power BI.                                                                                                                                                                                                                          |
| Batch Size                        | Set a batch size for your dataset.  Enter a batch size between **1** and **10,000**. The default is **300** records per API call.  You can adjust this setting to improve performance:   - To **reduce dataset execution time**, increase the batch size. - If you get an **Out of Memory** error, try decreasing the batch size. |

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Connector](/s/article/360042926274).