topic Re: Integrating Power BI to Splunk in Getting Data In

Integrating Power BI to Splunk

madhav_dholakia — Mon, 19 Feb 2024 10:57:42 GMT

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:

Steps:

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

and when clicked ok, above mentioned error is displayed.

Can you please suggest how I can fix this?

Thank you.

Re: Integrating Power BI to Splunk

madhav_dholakia — Wed, 28 Feb 2024 07:36:21 GMT

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

Re: Integrating Power BI to Splunk

WilmarMeyer — Tue, 04 Jun 2024 12:53:47 GMT

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

Re: Integrating Power BI to Splunk

madhav_dholakia — Mon, 10 Jun 2024 09:07:42 GMT

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

Re: Integrating Power BI to Splunk

Sabahat — Wed, 16 Oct 2024 12:02:41 GMT

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.

Re: Integrating Power BI to Splunk

madhav_dholakia — Mon, 09 Dec 2024 14:26:04 GMT

Hi @Sabahat - apologies for very late repsonse , I hope this has been already resolved but if not, this is visible for sc_admin role, I am not sure about Power User. Thank you.