Working with MS Fabric Warehouse
Creating MS Fabric Warehouse connection
To create MS Fabric Warehouse connection for processing semantic models, perform the following steps.
From the Toolbox, click Connections.
From the Actions menu ( ⋮ ) click Add Connection.
Enter the following details:
Parameter/Field | Comments/Description |
Name | Enter a unique name for the connection. |
Category | Select the Warehouse option. |
Provider | Select MS FABRIC from the list. |
Driver class | This field will be auto selected. The Driver class (com.microsoft.sqlserver.jdbc.SQLServerDriver) is required to connect to the MS Fabric. |
URL | In the URL field, enter the MS Fabric URL. For example, jdbc:sqlserver://mnt64huw2l3urevxzjinlgwvoq-5hsyj25oq23urofbwqjy3upaia.datawarehouse.fabric.microsoft.com:1433;database=dbo;encrypt=true;trustServerCertificate=false;loginTimeout=30; For more information, see Microsoft documentation. |
Authentication Type | Select User name password or Active Directory Service Principal. When selecting the Active Directory Service Principal, the following fields will be displayed.
NOTE: In the Kyvos 2025.5, only the Active Directory Service Principal is supported. |
Use as Source | This checkbox is auto selected. Enter Spark Read Method as JDBC |
Catalog Enabled | Select this checkbox to list different catalog created in the workspace. |
Properties | Click Properties to view or set properties. |
After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.
