Getting Data In

Integrating Power BI to Splunk

madhav_dholakia
Contributor

Hello,

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:

madhav_dholakia_0-1708340080783.png

 

Steps:

POWER BI Desktop -> Get Data -> Other -> ODBC -> 

madhav_dholakia_1-1708340136561.png

and when clicked ok, above mentioned error is displayed.

Can you please suggest how I can fix this?

Thank you.

Labels (3)
Tags (2)
0 Karma
1 Solution

madhav_dholakia
Contributor

Hello,

after checking this with Splunk Support Team - it was just a case of adding IP (of system where PowerBI Desktop is hosted) to allow list under Server Settings->IP Allow List Management-> "Search Head API Access".

Thank you.

Regards,

Madhav

View solution in original post

0 Karma

madhav_dholakia
Contributor

Hello,

after checking this with Splunk Support Team - it was just a case of adding IP (of system where PowerBI Desktop is hosted) to allow list under Server Settings->IP Allow List Management-> "Search Head API Access".

Thank you.

Regards,

Madhav

0 Karma

WilmarMeyer
New Member

Good Day,

On the below message. Adding the IP to the Server Settings. Does the Server Settings sit in PowerBI or in Splunk? To find List Management.

I have exactly the same error trying to connect to Splunk Cloud connection from PowerBI

Any help would be appreciated - Thanks

0 Karma

madhav_dholakia
Contributor

Hi @WilmarMeyer  - this is on Splunk Side: Server Settings->IP Allow List Management-> "Search Head API Access".

0 Karma

Sabahat
Loves-to-Learn Lots

Hi, 
I am facing the same issue, the Timed Out Reached error, but I am unable to find the IP Allow List Management-> "Search Head API Access" inside my server setting on the Splunk Cloud side.

Sabahat_0-1729080110933.png

 

 

0 Karma
Get Updates on the Splunk Community!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...