> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Fabric Service Principal Authentication Connector

## Intro

Microsoft Fabric is an end-to-end analytics and data platform designed for enterprises that require a unified solution. It encompasses data movement, processing, ingestion, transformation, real-time event routing, and report building. It offers a comprehensive suite of services, including Data Engineering, Data Factory, Data Science, Real-Time Analytics, Data Warehouse, and Databases. Use Domo's Microsoft Fabric connector for ingesting data into Domo. 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 Microsoft Fabric Service Principal Authentication account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft Fabric Service Principal Authentication connector user interface. To add DataSets, set update schedules, and edit DataSet information, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360063090013?language=en_US "Adding a DataSet Using a Connector").

## Prerequisites

To configure this connector, you must have the following:

* An installed Microsoft Azure app.
* Server Name
* Port number, database name
* Azure App Client ID and Client Secret
* HostNameInCertificate

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

1. Go to
   [https://portal.azure.com](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**.

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

1. Go to
   [https://portal.azure.com](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.

### 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/ "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`**

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.

<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/ "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/ "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**.

## Configuring the Connection

This section lists the options in the **Credentials** and **Details** panes on the Microsoft Fabric Service Principal Authentication 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](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

### 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" data-aura-rendered-by="33:198;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Server Name </td><td colspan="1" rowspan="1"> Enter the server name. </td></tr><tr><td colspan="1" rowspan="1"> Port Number </td><td colspan="1" rowspan="1"> Enter the port number. </td></tr><tr><td colspan="1" rowspan="1"> Database </td><td colspan="1" rowspan="1"> Enter the database name. </td></tr><tr><td colspan="1" rowspan="1"> Azure App Client ID </td><td colspan="1" rowspan="1"> Enter the Azure App Client Id. </td></tr><tr><td colspan="1" rowspan="1"> Azure App Client Secret </td><td colspan="1" rowspan="1"> Enter the Azure App Client Secret. </td></tr><tr><td colspan="1" rowspan="1"> HostNameInCertificate </td><td colspan="1" rowspan="1"> Enter the hostNameInCertificate obtained from the show database connection strings. </td></tr></tbody></table>

For more information about obtaining these credentials, see [Prerequisites](#h_04264b0c-3d07-4765-accb-0708e0e6d456 "Prerequisites"), above.

Once you have entered valid Microsoft Fabric Service Principal Authentication credentials, you can use the same account any time to create a new Microsoft Fabric Service Principal Authentication DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector Accounts](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector Accounts").

### Details Pane

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

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:198;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"> Query Type </td><td colspan="1" rowspan="1"><p> Select the query type from the drop-down list. </p><ul><li> Custom Query </li><li> Query Builder </li></ul><table><tbody><tr><th colspan="1" rowspan="1"><p> QueryType </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr><tr><td colspan="1" rowspan="1"> Custom Query </td><td colspan="1" rowspan="1"> Enter the query to execute. </td></tr><tr><td colspan="1" rowspan="1"> Query Builder </td><td colspan="1" rowspan="1"> Select a table and fields to autogenerate your query. </td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"> Query </td><td colspan="1" rowspan="1"> Enter the SQL query to execute. </td></tr><tr><td colspan="1" rowspan="1"> Database Schema </td><td colspan="1" rowspan="1"> Select the schema from the drop-down list. </td></tr><tr><td colspan="1" rowspan="1"> Database Tables </td><td colspan="1" rowspan="1"> Select the database table name from the drop-down list. </td></tr><tr><td colspan="1" rowspan="1"> Table Columns </td><td colspan="1" rowspan="1"> Select the table Columns. </td></tr><tr><td colspan="1" rowspan="1"> Query Helper </td><td colspan="1" rowspan="1"> This query is <b> automatically generated </b> from your field selections. Manual edits here will not update the selections in the Field table above. </td></tr></tbody></table>

### 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](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").