Power BI

Power BI, in conjunction with TileDB, offers a comprehensive business intelligence platform that enables users to connect, transform, and visualize data stored in TileDB Cloud. With Power BI's intuitive interface and robust analytics features, organizations can gain valuable insights, create interactive reports and dashboards, and make data-driven decisions effectively.

Power BI showing taxi data stored in TileDB-Cloud

Set up

In order to use the JDBC driver for Power BI, a JDBC-to-ODBC bridge is required. We have used and tested the one from ZappySys. Follow the instructions below:

Step 1: Launch the "ODBC Data Sources" application

Step 2: Click add

Step 3: Select the "ZappySys JDBC Bridge Driver" option

Step 4: Complete the details. The last part of the "Connection String" should be your API token

Then, click ok and your bridge should be set up. Now, open PowerBI Desktop and follow these steps:

1. Click on "Get Data" in the Home tab.

2. Select "More..." and search for "ODBC" in the data connectors list.

3. Choose the "ODBC" option and click "Connect".

4. In the ODBC dialog, select the bridged JDBC driver as a data source from the list.

5. By expanding the "Advanced options" section you can insert a custom SQL query. Otherwise click next and you will be displayed your owned, shared and public arrays from TileDB-Cloud