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

Introduction

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.

Give your data source a name. I gave: Splunk_api2

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

It will show something like:

Power BI Configuration

Click on Get Data.

Search for odbc

Select your created odbc connection 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.

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

I hope you enjoyed the post.