Splunk Cloud Platform

How to Power Bi integration with Splunk- Getting Error

saurabhtathode
Engager

PowerBI_error.PNGPowerBI_datasource.PNGHello All,

 

We are trying to achieve Power BI integration with Splunk. We have Power BI installed on windows machine and we also installed ODBC driver to connect to Splunk.

As part of configuration we added credentials (same with which we connect to our splunk cloud instance) and URL in Power BI Get Data options but we are getting below error:

"Details: "ODBC: ERROR [HY000] [Splunk][SplunkODBC] (40) Error with HTTP API, error code: Couldn't connect to serverERROR [HY000] [Splunk][SplunkODBC] (40) Error with HTTP API, error code: Couldn't connect to server"

I am attaching connection screenshot and error screenshot. Please let me know if we can add any more information.

Please try to help on same as this will ease reporting to great extent 🙂

Labels (2)

99eaglez
Explorer

Probably proxy server (or firewall).

Typically proxy server because the ODBC driver is not proxy aware like your internet browser is.

This is why others mentioned configure the proxy without explanation.

The typical solution is to add an environmental variable that the ODBC driver can see.

I would recommend testing it using the following process:

  1. At the command line (in Windows) enter setx http_proxy <proxy_ip>:<proxy_port> (example setx http_proxy 132.50.12.1:443)
  2. Restart your ODBC Program (ex, PowerBi)
  3. Retest your connection

If it fails, add the https_proxy the same way. If it succeeds, add it the system permanently. 

Ref# Configure the proxy server - Splunk Documentation
libcurl - programming tutorial
Set up proxy using http_proxy & https_proxy environment variable in Linux? | GoLinuxCloud
windows - Command line to remove an environment variable from the OS-level configuration - Stack Ove...

0 Karma

Roy_9
Motivator

@saurabhtathode Have you installed ODBC drivers on the server?

Drivers needs to be downloaded and place in driver's directory under the Power BI app? My guess.

0 Karma

ekretsch
Engager

I am experiencing the same problem. Was there any resolution to this one?

0 Karma

Roy_9
Motivator

@ekretsch Have you installed ODBC drivers on the server?

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...