Configure the Splunk ODBC driver with Microsoft Power BI

You can access Splunk Enterprise data from Microsoft Power BI (32-bit or 64-bit) using the Splunk ODBC Driver version 3.0 and later.

To use the Splunk 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 Enterprise instance in the Connection string window. For example, URL=https://10.202.10.113:8089
   
4. In the ODBC driver menu, enter the username and password of your Splunk Enterprise 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 Enterprise server.
   
7. In the Navigator menu, expand the "All" menu, check the checkbox of each desired saved search, and click Load.
   
8. Click the Table view to view your data.

The saved search may load slowly.