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 includes 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 to ingest data into Domo. You can connect to your Microsoft Fabric account in the Data Center. This topic discusses the fields and menus that are specific to the Microsoft Fabric connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Microsoft Fabric account and create a DataSet, you need the following:
  • Server Name
  • Port number
  • Database name
  • Username and Password for the server
  • Hostname in Certificate

​
Connecting to Your Microsoft Fabric Account

This section enumerates the options in the Credentials and Details panes on the Microsoft Fabric Connector page. The components of the other panes on 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 Microsoft Fabric account. The following table describes what is needed for each field:

Field

Description

Server Name Enter the server name.
Port Enter the port number.
Database Enter the database name.
Username Enter the username for the server.
Password Enter the password for the server.
Hostname in Certificate Enter the hostNameInCertificate obtained from the show database connection strings.
Once you have entered valid Microsoft Fabric credentials, you can use the same account at any time to create a new Microsoft Fabric 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

Menu Description
Query Type
Query Type Description
Custom Query Enter the query you want to execute.
Query Builder Select a table and field to autogenerate your query.
Query Enter the SQL query to execute.
Database Schemas Select the schema.
Database Tables Select the table.
Table Columns Select the columns.
Query Helper This field is automatically generated using the above selected fields. Updating the auto generated query will not update your 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.