How to Connect Oxla Cloud with PowerBI
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
Import
option as DirectQuery
support is experimental for now-
Fill in the credentials for your cluster and click Connect
-
Select the desired tables from the list and click Load
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.
.pem
format, while importing it to Certificate Store, make sure that file selector is set to All files (*.*)
as shown on screenshot belowOnce it’s done, Oxla Root CA
should be visible in the Certificate Store