Using Power BI to run SQL queries
Power BI is a business analytics service by Microsoft, that provides interactive visualizations and a business intelligence interface for creating reports and dashboards.
Supported versions
You can use the Desktop version of Power BI (Windows only) to connect to GeoSpock database, over an ODBC connection. Power BI recommends using Simba’s ODBC driver.
ODBC configuration settings
To connect to GeoSpock database using Power BI, select ODBC and use the following settings:
| Field | Description |
|---|---|
| Data source name (DSN) | Simba Presto |
| Connection string (non-crediential properties) | Port=<port>;Host=<host>;URL=https://<host>:<port>; Where: <port> = 8446 <host> = the hostname of GeoSpock database: sqlaccess.<database_domain_name> So, for example, if your platform domain is geospock.example.com, <host> would be: sqlaccess.geospock.example.com |
| SQL statement | (optional) enter your SQL query here |
| Username | Your GeoSpock database username |
| Password | The password for your GeoSpock database account |
| Credential connection string properties | SSL=1;AuthenticationType=LDAP Authentication; |
For more information about Power BI, refer to the Microsoft documentation.