# Microsoft Fabric

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

<InfoBox>

Available on the [Enterprise Premier plan](https://cube.dev/pricing).
[Contact us](https://cube.dev/contact) for details.

</InfoBox>

## Setup

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

<Screenshot src="https://ucarecdn.com/ecfef0be-8122-43c1-acca-7e9a5806b6fb/"/>

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][link-fabric-auth]:

* 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`][ref-schema-ref-types-formats-countdistinctapprox] can
not be used in pre-aggregations when using Microsoft Fabric as a source
database.

## Pre-Aggregation Build Strategies

<InfoBox>

To learn more about pre-aggregation build strategies, [head
here][ref-caching-using-preaggs-build-strats].

</InfoBox>

| Feature       | Works with read-only mode? | Is default? |
| ------------- | :------------------------: | :---------: |
| Simple        |             ✅             |     ✅      |
| Batching      |             -              |      -      |
| Export Bucket |             -              |      -      |

By default, Microsoft Fabric uses a [simple][self-preaggs-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.

[link-fabric]: https://www.microsoft.com/en-us/microsoft-fabric/
[link-fabric-auth]: https://learn.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver16#properties
[ref-caching-using-preaggs-build-strats]:
  /product/caching/using-pre-aggregations#pre-aggregation-build-strategies
[ref-schema-ref-types-formats-countdistinctapprox]: /product/data-modeling/reference/types-and-formats#count_distinct_approx
[self-preaggs-simple]: #simple