How to connect Supabase to Microsoft Power BI

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 downloaded1.

🔑 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.

🛠 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

Supabase Docs: Connecting to Postgres

Supabase IPv4 Addon

GitHub Discussion #13885: Power BI Connection

DEV Community: jenny

How to connect Supabase to Microsoft Power BI

🛠 Troubleshooting

📚 References