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!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...