Splunk® ODBC Driver

Install and Use Splunk ODBC Driver

Acrobat logo Download manual as PDF


Acrobat logo Download topic as PDF

Configure the Splunk ODBC driver with Microsoft Power BI

The Splunk Open Database Connectivity (ODBC) driver is not compatible with Microsoft Power BI on macOS

You can access Splunk instance data from 32-bit or 64-bit Microsoft Power BI using the Splunk Open Database Connectivity (ODBC) Driver version 3.0 and higher.

Follow these steps to use the Splunk Open Database Connectivity (ODBC) Driver to get Splunk data into Microsoft Power BI:

  1. Open Power BI Desktop. On the Welcome screen, click Get Data.
  2. In the Get Data window, select Other > ODBC. Click Connect.
  3. In the From ODBC window, select the Splunk ODBC data source name (DSN), and click OK. If you cannot connect, open Advanced Options, and enter the URL of your Splunk platform instance in the Connection string window. For example, URL=https://10.202.10.113:8089
    This screenshot shows the Power BI configuration menu. The list includes the data source name (DSN), and the URL of the user's Splunk platform instance.
  4. In the ODBC driver menu, enter the username and password of your Splunk platform instance, and click Connect.
  5. In the Navigator window, select ODBC > All from the Display Options menu.
  6. In the ODBC driver window, enter the username and password for Splunk instance, and click Connect. Microsoft connects to your Splunk platform server.
    This screenshot shows the configuration menu. The list includes Username and Password.
  7. In the Navigator menu, expand the "All" menu, check the checkbox of each desired saved search, and click Load.
    This screenshot shows the list of available tables. The list includes the user's Splunk saved search.
  8. Click the Table view to view your data.

The saved search may load slowly.

Last modified on 13 February, 2023
PREVIOUS
Configure the Splunk ODBC driver to work with Tableau Desktop on Microsoft Windows
  NEXT
Access data models using the Splunk ODBC Driver

This documentation applies to the following versions of Splunk® ODBC Driver: 3.1.0, 3.1.1


Was this documentation topic helpful?


You must be logged into splunk.com in order to post comments. Log in now.

Please try to keep this discussion focused on the content covered in this documentation topic. If you have a more general question about Splunk functionality or are experiencing a difficulty with Splunk, consider posting a question to Splunkbase Answers.

0 out of 1000 Characters