Integrate Kore.ai with Power Bi

[bavleen.a.kaur (Bavleen Kaur)]

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

Thanks

[srujan.madderla]

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

[bavleen.a.kaur (Bavleen Kaur)]

Hi @srujan.madderla

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

Thanks

[srujan.madderla]

Hi @bavleen.a.kaur,

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

How to generate JWT tokens for Kore.ai public APIs

The public APIs can be helpful in accomplishing some bot related operations from outside the bot-builder, and toward achieving CI (continuous integration)/CD (continuous development) goals. For Kore platform, the public APIs are listed here. Please note that all the Kore.ai public API authenticate the requester using JWT. So as a developer or an administrator you are expected and requested to keep the JWT token safe under access control and keep changing it often as needed. To use the APIs you…

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

Thank you,
Srujan Madderla

[bavleen.a.kaur (Bavleen Kaur)]

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

Thanks

[bavleen.a.kaur (Bavleen Kaur)]

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

[srujan.madderla]

Hi @bavleen.a.kaur ,

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

Connection from Power BI

Hi! I am trying to get the conversations from Power BI, using the API. The request is working fine for me in Postman (getMessages endpoint, JWT token as a header). But when replicating it from Power Query, I am seeing error 400. Has anybody connected from Power BI via API? The Power Query code I tried out is: = Json.Document(Web.Contents(“https://de-bots.kore.ai/api/public/stream//getMessages”, [Headers=[#“Content-Type”=“application/json”, #“auth”=]]))

Regards,
Srujan Madderla

[shiva.borra (Shiva Kumar Boora)]

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