Power BI - How to Connect to Splunk live connection with odbc Splunk driver

August 25, 2021


Power BI is a wonderful tool to give life to your data, by rendering awesome visualizations with the help of data.

In this post, we will learn how to connect to Splunk lookup by using Splunk ODBC driver.

Splunk ODBC Driver

Search for Splunk ODBC driver for windows, and you will get link to download the driver. The URL I got is: https://splunkbase.splunk.com/app/1606/

You need to signup to Splunk, only then you will be able to download the driver. And, then select your desired OS.

For windows, I got a zip file: splunk-odbc_311-windows.zip.

Unzip the file, and install the driver by choosing 32bit or 64bit installer file. In my case, its SplunkODBC64

The setup might ask for a splunk connection. You can leave it as it is for now.

Configure Splunk Connection with ODBC Driver

Open the ODBC app.


Under User DSN, click on Add button.

ODBC App Add connection

Give your data source a name. I gave: Splunk_api2

Put your username, and password. Also, put your Splunk URL (https://yourserver.com:443)

ODBC App connection

It will show something like:

Splunk connection

Power BI Configuration

Click on Get Data.

Power bi Data source

Search for odbc

Datasource search

Datasource odbc

Select your created odbc connection name

ODBC Source

Datasource ODBC Name

Once you select your connection, it fetches available lookups. And you can click on anyone of them, and it will also preview the data on right side.

ODBC Splunk Lookups

Once you import it, your selected data will be shown on the right side.

I hope you enjoyed the post.

Similar Posts

Latest Posts