How to connect Supabase to Microsoft Power BI

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:

1. Press Win + R, type mmc, and hit Enter
2. Go to File → Add/Remove Snap-in…
3. Add Certificates, Add>, select Computer account → Local computer
4. Navigate to: Certificates → Trusted Root Certification Authorities

5. Right-click Certificates > All Tasks → Import

6. 

7. Use the wizard to import the downloaded supabase ssl certificate .crt file

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