To get data into Windows tools like Power BI and Excel we need and additional JDBC to ODBC bridge tools like ZappySys.
Download ZappySys
https://zappysys.com/products/odbc-powerpack/
From Windows search for ‘ODBC’
Click ODBC Data Sources (64-bit)
Click Add
Select ZappySys JDBC Bridge Driver
Click Finish
Enter the necessary fields
Data source name ← Any name
Connection string ← jdbc:data-basics:rest:https://api.data-basics.net/apihub/apis;logFile=/path/log.txt;
Driver class ← com.databasics.jdbc.Driver
JDBC driver path ← Browse to jdbc jar
User name ← username
User password ← password
Click Test Connection
Enter a test query and click Preview Data
If all looks good, click OK