How to Connect Supabase to Microsoft Power BI Desktop and Power BI Service

jenny — Mon, 09 Jun 2025 13:46:43 +0000

Supabase is an open-source backend-as-a-service that provides a PostgreSQL database, authentication, and storage services.

Microsoft Power BI is a powerful business analytics tool that enables users to visualize and share insights from their data.

Connecting Supabase to Power BI allows you to create dynamic dashboards and reports based on your Supabase data.

✅ Prerequisites

A Supabase project
Microsoft Power BI Desktop
Supabase SSL certificate downloaded.

🔑 Get Your Supabase Connection Details
Go to Dashboard → connect in your Supabase project and copy

Host: Use the Session Pooler URL (e.g. aws-0-xyz.pooler.supabase.co)
Port: 5432
Database:typically postgres
User: typically postgres.project-ref
Password:xxxxxxxx

Download the .crt file from the SSL Configuration section.

🛡️ Please note: Supabase's Direct Connection uses IPv6 by default, if your network doesn’t support IPv6, either enable the IPv4 Addon or use the Session Pooler, which serves as an alternative when connecting over IPv4.

🧩 Import Supabase SSL Certificate
Power BI requires the root SSL certificate to be trusted. Here’s how to import it:

Press Win + R, type mmc, and hit Enter
Go to File → Add/Remove Snap-in…
Add Certificates, Add>, select Computer account → Local computer
Navigate to: Certificates → Trusted Root Certification Authorities
Right-click Certificates > All Tasks → Import
Use the wizard to import the downloaded supabase ssl certificate .crt file
Ensure it’s placed in the Trusted Root Certification Authorities

You should see a success confirmation. Power BI can now trust SSL-secured connections.

📊 Connect to Supabase from Power BI

Open Power BI Desktop
Select Get Data → PostgreSQL database
Fill in:
- Host: aws-0-xyz.pooler.supabase.co
- Database: Typically postgres
Choose Database authentication and enter your Supabase username and password
Click OK

In the Navigator window, select the data you require, then either Load to import it directly or Transform Data to shape it before loading

After this, you’re all set! You’ve now connected Power BI to your Supabase PostgreSQL database using the most streamlined and reliable method.

Power BI Service

If you're connecting from Power BI Service instead of Power BI Desktop, the setup is slightly different.

Power BI Service can fail during PostgreSQL connection setup with an SSL certificate validation error.

Unlike Power BI Desktop, there usually is no place in the online Power BI Service flow to import and trust the certificate manually.

What to do in Power BI Service

When creating the PostgreSQL connection in Power BI Service, use:

Authentication kind: Basic
Privacy level: None
Use encrypted connection: unchecked

Then enter your database host, database name, username, and password.

Important note about security

Unchecking Use encrypted connection is a workaround, but it is less secure because the connection will not use SSL/TLS encryption.

If your workflow requires encrypted connections, Power BI Desktop is usually the better option because it allows certificate trust to be handled on the client machine.

🛠 Troubleshooting

SSL Errors: Ensure certificate was imported under Local Computer → Trusted Root
Connection Timeout: Use the Pooler URL if IPv6 isn’t supported in your network
Network Limitations

📚 References