Integrate Kore.ai with Power Bi

Hi Team,
Please guide me how can I integrate kore.ai with power bi.

Thanks

Hi @bavleen.a.kaur,

Unfortunately, we don’t have any documentation that talks about integration for Kore.ai with Microsoft Power BI.
But this can be achieved through public APIs provided by Kore.ai which can help pull some information from the bots,.
For example, conversation history data, NLP metrics, etc.
Please take a look at https://developer.kore.ai/docs/bots/api-guide/api-list/
The output of these APIs is in JSON format and can be processed and fed to the mentioned third-party systems.

Regards,
Srujan Madderla

Hi @srujan.madderla

I tried these api but I’m getting authentication failed.
Please guide me on this.

Thanks

Hi @bavleen.a.kaur,

Please refer to the below knowledge content post which will help you to resolve the authentication error.

If you still face any issue, please revert back we will be glad to assist you.

Thank you,
Srujan Madderla

Hi
I have tried this method that api is working in postman but when connecting in power bi it’s not getting authenticated.

Thanks


This the error I’m getting while connecting.
In username I’m giving JWT token.
Please guide.

Hi @bavleen.a.kaur ,

Please refer to the below community post, this might be helpful for you.

Regards,
Srujan Madderla

Hi All,
I found a way to connect kore.ai Public API to Power BI.

Follow the below steps and you can be achieving it
Step 1 – Required Data
Public API, Headers Details like Content-Type and auth and Query prams and Body if you got all

Then Use below Script


let
    url = "Public API",
    
    // Defining headers separately, with the auth token
    headers = [
        auth = "token you generated in jwt.io",
        #"Content-Type" = "application/json"
    ],
    
    // POST request with headers and content
    response = Web.Contents(url, [
        Headers = headers,

//Replace body based on your needs
        Content = Text.ToBinary("{""dateFrom"": ""2024-07-20"", ""dateTo"":""2024-08-12"", ""isDeveloper"": true}")
    ]),
    
    // Parsing the JSON response
    jsonResponse = Json.Document(response)
in
    jsonResponse

Now you can see the data
If you are facing credential issue then keep it as anonymous


If you still have any issue in connection Please reach out to shivakumarboora09@gmail.com