PowerBI Rest API from splunk system as splunk system using curl command for Rest API Calls?

[Anonymous]

Hi I am PowerBI DEV for IBM. Currently working on project where I need to import data from Splunk System using Rest API. Splunk System Rest API can be called using Curl Command. PowerBI is not supporting Curl command. Could you please advise me how can I use C# or Powershell in PowerBI? Thanks

[v-qiuyu-msft]

Hi @Anonymous, 

To use REST API calls to retrieve data from data source in Power BI, you can use Web data source to do it in Power BI desktop. You can take a look at the samples below:

https://community.powerbi.com/t5/Community-Blog/Calling-REST-APIs-and-Parsing-JSON-made-simple-with-Power-BI/ba-p/43649

https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

Best Regards,
Qiuyun Yu 

[Anonymous]

Dear Qiuyun,

Thanks for your kind reply, I have gone through these posts. Bascially challange I am facing is I have to run two curel command calls for search Rest API in splunk. One to execute the search and other one is get the result. And Curel command is not supported in PowerBI.

There are other ways to access it is via python script or C# to refresh the token.

Anyone knows how to run other programming languages from PowerBI desktop or PowerBI Services.

I would appericiate  your comments or advise.

[v-qiuyu-msft]

Hi @Anonymous, 

In Power BI desktop, we can run Python script in Query Editor. You can refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

Best Regards,
Qiuyun Yu