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.
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:
Then, click ok and your bridge should be set up. Now, open PowerBI Desktop and follow these steps:
Click on "Get Data" in the Home tab.
Select "More..." and search for "ODBC" in the data connectors list.
Choose the "ODBC" option and click "Connect".
In the ODBC dialog, select the bridged JDBC driver as a data source from the list.
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
