> For the complete documentation index, see [llms.txt](https://help.daasity.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.daasity.com/core-concepts/bi-tools/power-bi/connecting-power-bi-desktop-to-daasity.md).

# Connecting Power BI Desktop to Daasity

Connect Power BI Desktop to Daasity's Snowflake warehouse using keypair authentication.

{% hint style="warning" %}
This guide covers **Power BI Desktop only**. Power BI Cloud (Power BI Service) is not currently supported for direct connection to your Daasity warehouse.
{% endhint %}

### Overview

Power BI Desktop connects to your Daasity data via the Snowflake connector using keypair authentication. Keypair is required because Snowflake has deprecated password-based authentication for programmatic connections.

Once connected, your full set of Daasity unified schemas and data marts is available in Power BI's Navigator for import or DirectQuery.

***

### Prerequisites

**Software**

* Power BI Desktop installed on your machine

**Credentials**

* Snowflake server URL
* Snowflake warehouse name
* Snowflake username
* Private key in PEM format
* Private key passphrase — only if your key is encrypted

***

### Step 1: Open the Snowflake connector

In Power BI Desktop, go to the **Data** section and click **Get data**. Select **More…**, search for **Snowflake**, and click **Connect**.

<figure><img src="https://410725593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FamTMWiPne1v1V3L7mbuj%2Fuploads%2Fy4tTWSXpmHimk0chmkFl%2Funknown.png?alt=media&amp;token=a5793d5d-e7db-4198-b6dd-5c98c43db92d" alt=""><figcaption></figcaption></figure>

***

### Step 2: Configure server and warehouse

Enter your Snowflake server URL and warehouse name. Advanced options are available but not required for basic connectivity.

<figure><img src="https://410725593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FamTMWiPne1v1V3L7mbuj%2Fuploads%2FRbeORVyA1yg02Bn0uyvS%2Funknown.png?alt=media&amp;token=ead47989-b4a8-4c1d-b002-49d47209f8a6" alt=""><figcaption></figcaption></figure>

### Step 3: Authenticate with your key pair

On the authentication page, select **Key Pair** and enter:

* Your Snowflake username
* Your private key (must be PEM format — not RSA)
* Your passphrase, if applicable

<figure><img src="https://410725593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FamTMWiPne1v1V3L7mbuj%2Fuploads%2FTuOE16YIkL0WGUlpfQZM%2Funknown.png?alt=media&amp;token=c9d02413-ef6a-4d4e-a0e5-3103f402ca4b" alt=""><figcaption></figcaption></figure>

Click **Connect**.

***

### Step 4: Verify the connection

On success, your Daasity database appears in Power BI's Navigator. You'll see your schemas (BSD, CALENDAR, DRP, and others) and can load or transform tables from there.

<figure><img src="https://410725593-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FamTMWiPne1v1V3L7mbuj%2Fuploads%2FavXAhFP5og26i87pdaCu%2Funknown.png?alt=media&amp;token=0b9307cc-b574-433d-bfa7-0aba8811cdd1" alt=""><figcaption></figcaption></figure>

***

### **Having Issues?**&#x20;

Contact <support@daasity.com>.