topic Re: How to Power Bi integration with Splunk- Getting Error in Splunk Cloud Platform

How to Power Bi integration with Splunk- Getting Error

saurabhtathode — Wed, 15 Jun 2022 17:04:45 GMT

Hello 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 🙂

Re: Power Bi integration with Splunk

ekretsch — Wed, 15 Jun 2022 15:35:20 GMT

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

Re: How to Power Bi integration with Splunk- Getting Error

Roy_9 — Fri, 17 Jun 2022 16:47:04 GMT

@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.

Re: Power Bi integration with Splunk

Roy_9 — Sat, 18 Jun 2022 05:44:50 GMT

@ekretsch Have you installed ODBC drivers on the server?

Re: How to Power Bi integration with Splunk- Getting Error

99eaglez — Tue, 04 Feb 2025 23:19:51 GMT

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:

At the command line (in Windows) enter setx http_proxy <proxy_ip>:<proxy_port> (example setx http_proxy 132.50.12.1:443)
Restart your ODBC Program (ex, PowerBi)
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...