Forum Discussion

GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Splunk and Power BI

Hi Everyone,   The IT manager has mentioned Splunk may be a useful tool to extract data we need from some of our machines. I was wondering if anyone has linked the Splunk data with Power BI or know...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Below are the steps you need to perform to connect the splunk data with power Bi.

- Download the odbc 64 bit driver from

https://splunkbase.splunk.com/app/1606/

- Install the driver and create a new DSN connection from splunk data source in odbc 64 driver.

- Fill the  server details userid and password.

- Goto Power Bi and add new connection.

- Click on odbc and then provide credetials for splunk server and then connect.

-Select the tables from the database.

-load the data in power bi.

 

hope it will help.

 

Thanks,

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am able to use the 64-bit Splunk ODBC driver with Power BI Desktop just fine, but when I install the 64-bit version on our Windows Server 2012 R2 and attempt to add a data source to the gateway in the service then I get this error. At one point there was an error about "C:\Program Files\Splunk ODBC Driver\lib\SplunkDSII.dll" not being found, but it is installed. From what I have read this could indicate that the wrong version (32 vs 64) version of the driver is installed but I confirmed I do have the 64-bit. Any ideas?

Savers Data Gateway:Unable to connect to the data source undefined.
Underlying error code:-2147467259
Underlying error message:ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath:dsn=Splunk ODBC Driver
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error