Microsoft Fabric

Microsoft Fabric is an all-in-one analytics solution for enterprises. It offers a comprehensive suite of services, including a data warehouse.

Available on the Enterprise Premier plan. Contact us for details.

Setup

When creating a new deployment in Cube Cloud, at the <Btn>Set up a database connection</Btn> step, choose <Btn>Microsoft Fabric</Btn>.

Then, provide the <Btn>JDBC URL</Btn> connection string in the following format. See below for tips on filling in <SERVER_NAME>, <DATABASE_NAME>, <AUTH_TYPE>, <USER_NAME>, and <PASSWORD>.

jdbc:sqlserver://;serverName=<SERVER_NAME>.datawarehouse.pbidedicated.windows.net;database=<DATABASE_NAME>;encrypt=true;Authentication=<AUTH_TYPE>;UserName=<USER_NAME>;Password=<PASSWORD>

Optionally, fill in <Btn>Database</Btn> if you'd like to override the database name from the JDBC URL.

Server and database name

To obtain your data warehouse server name and database name, navigate to your data warehouse in Microsoft Fabric and click on the cog icon to open <Btn>Settings</Btn>:

<Screenshot src="https://ucarecdn.com/ed1b2916-ac3e-4493-8eee-e2fd5dd89dbc/" highlight="inset(5% 79% 76% 5% round 10px)" />

On the <Btn>About</Btn> page, you can find the database name (<DATABASE_NAME>) under <Btn>Name</Btn> and the server name (<SERVER_NAME>) under <Btn>SQL connection string</Btn>:

<Screenshot src="https://ucarecdn.com/7818f783-4bd6-431c-87dd-c5169232c91b/" highlight="inset(1% 1% 30% 23% round 10px)" />

Authentication

Microsoft Fabric supports two authentication types:

• Use ActiveDirectoryPassword as <AUTH_TYPE> to connect using a Microsoft Entra principal name and password. Provide principal name as <USER_NAME> and password as <PASSWORD>.
• Use ActiveDirectoryServicePrincipal as <AUTH_TYPE> to connect using the client ID and secret of a service principal identity. Provide client ID as <USER_NAME> and secet as <PASSWORD>.

Pre-Aggregation Feature Support

count_distinct_approx

Measures of type count_distinct_approx can not be used in pre-aggregations when using Microsoft Fabric as a source database.

Pre-Aggregation Build Strategies

To learn more about pre-aggregation build strategies, head here.

By default, Microsoft Fabric uses a simple strategy to build pre-aggregations.

Simple

No extra configuration is required to configure simple pre-aggregation builds for Microsoft Fabric.

Batching

Microsoft Fabric does not support batching.

Export Bucket

Microsoft Fabric does not support export buckets.