# Connecting Power BI Desktop to Daasity

{% 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="/files/mPL4f9E79DJ3gwiDMdVS" 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="/files/UDWjfZC9JfsVDo7TOIb5" 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="/files/SaxCm9mU9XdgfWZ7pL1r" 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="/files/sSiIeiv1zWWCKI7pKQoP" alt=""><figcaption></figcaption></figure>

***

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

Contact <support@daasity.com>.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/bi-tools/power-bi/connecting-power-bi-desktop-to-daasity.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.