Setting up your Oxla Cloud cluster

In order to connect Power BI with Oxla Cloud, you need to have a running cluster. If you don’t have one yet, you can easily create it by following our step by step Oxla Cloud: Quickstart Guide.

  • If you already have an existing cluster that you want to use with Power BI, click the three dots next to it and select Start

  • For viewing the connection details please select Connect info from the menu available next to the running cluster:

    • Address: cluster address
    • Port: port number
    • Username: username of the user/role that has access to the cluster
    • Server certificate: certificate of the server that you can download to be uploaded to the Certificate Store if needed

Connecting Power BI with Oxla Cloud

Right now, that you’ve successfully gone through Oxla Cloud cluster creation flow and have its connection information, it’s time to set up Power BI

  • Firstly, start your Power BI Desktop application and click on Get Data

  • Then you need to look for PostgreSQL database connector

  • Configure the connector with your cluster address and use oxla as a database name

For the Data Connectivity mode we highly recommend Import option as DirectQuery support is experimental for now
  • Fill in the credentials for your cluster and click Connect

  1. Select the desired tables from the list and click Load

That’s it! The data source is connected.

Troubleshooting

If you encounter an invalid certficiate error on connection attempt, about remote certificate being invalid, please download Server Certificate from connection details of your cluster and follow this official tutorial for adding the certificate to the Certificate Store.

Oxla Cloud certificate is in .pem format, while importing it to Certificate Store, make sure that file selector is set to All files (*.*) as shown on screenshot below

Once it’s done, Oxla Root CA should be visible in the Certificate Store