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.
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:
|Data source name (DSN)||
|Connection string (non-crediential properties)||
|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||
For more information about Power BI, refer to the Microsoft documentation.