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!

AppDynamics Summer Webinars

This summer, our mighty AppDynamics team is cooking up some delicious content on YouTube Live to satiate your ...

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...