Skip to main content

​
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/). 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.

​
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.
  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.
  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.
  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: Ensure to copy the Value and not the Secret ID.

​
Enabling the ‘Allow public client flows’

  1. Go to 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.
  1. Go to 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.

​
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:

Field

Description

Server Name Enter the server name.
Port Number Enter the port number.
Database Enter the database name.
Azure App Client ID Enter the Azure App Client Id.
Azure App Client Secret Enter the Azure App Client Secret.
HostNameInCertificate Enter the hostNameInCertificate obtained from the show database connection strings.
For more information about obtaining these credentials, see 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.

​
Details Pane

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

Menu

Description

Query Type

Select the query type from the drop-down list.

  • Custom Query
  • Query Builder

QueryType

Description

Custom Query Enter the query to execute.
Query Builder Select a table and fields to autogenerate your query.
Query Enter the SQL query to execute.
Database Schema Select the schema from the drop-down list.
Database Tables Select the database table name from the drop-down list.
Table Columns Select the table Columns.
Query Helper This query is automatically generated from your field selections. Manual edits here will not update the selections in the Field table above.

​
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.