Connecting Power BI Desktop to Daasity

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

This guide covers Power BI Desktop only. Power BI Cloud (Power BI Service) is not currently supported for direct connection to your Daasity warehouse.

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.

---

Step 2: Configure server and warehouse

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

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

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.

---

Having Issues?

Contact [email protected].