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.