Integration of a Chatbot from my Org in Power BI Reports

[yashwant101]

Hi All,

There is a chatbot created inside my organization. I want to use it in my Power BI reports. Is there any way that I can use it?

Any help is highly appreciated.

Regards,

Yashwant

[Vijay_Chethan · Accepted solution]

Hello yashwant101,
the usecase that you have asked might not be possible currently in power bi as
the data exhange would be happening real time while power bi might not able to fetch them even if we use the chatbot via apis, might need constant refreshin report

on alternative is using power automate to keep button exclusive for chatbot and on click of this, you might want to trigger the automate flow
and in the same flow you might want to refresh thepower bi dataset as well
well using power bi api ,you can refresh power bi dataset so you could store your session details and session chats in that data set

if this helps in any way, please mark as solution

[v-mdharahman · Accepted solution]

Hi @yashwant101,

Thanks for reaching out to the Microsoft fabric community forum.

Yes, it is possible to use your internal chatbot within a Power BI report, but the approach depends on how the chatbot is hosted and how you'd like users to interact with it.

As already suggested by @BhavinVyas3003, if the chatbot is available as a web app (like through Azure or an internal site), you can try embedding it using a custom visual such as the HTML Viewer in Power BI. This lets you display web content directly inside the report. Just note that some bots might block embedding due to security settings like iframe restrictions, so it depends on how your chatbot is configured.

Another practical option is suggested by @Vijay_Chethan, to add a button in your report that opens the chatbot in a separate browser tab or window. This avoids any embedding limitations and ensures full functionality.

Also check if your bot is deployed in Microsoft Teams, you can also link it through a Teams deep link from Power BI so users can chat with it directly in Teams.

I would also take a moment to thank @Vijay_Chethan and @BhavinVyas3003, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

If this post helps then please mark it as a solution, so that other members find it more quickly.

Thank you.

[v-mdharahman]

Hi @yashwant101,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.

If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

[v-mdharahman]

Hi @yashwant101,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.

Thank you.

[v-mdharahman]

Hi @yashwant101,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[BhavinVyas3003]

If your chatbot has a web/iframe URL (e.g., from Power Virtual Agents or a custom web app):

1. In Power BI Desktop, import the "HTML Viewer" custom visual from AppSource.

2. Add the chatbot iframe/embed code as a measure or field.

3. Place the HTML Viewer visual on your report and bind it to the embed code.

[Vijay_Chethan]

might not exactly work like expected and on top of that,HTML viewer(certified) at least is paid
and might be useful in long run

[Vijay_Chethan · Accepted solution]

Hello yashwant101,
the usecase that you have asked might not be possible currently in power bi as
the data exhange would be happening real time while power bi might not able to fetch them even if we use the chatbot via apis, might need constant refreshin report

on alternative is using power automate to keep button exclusive for chatbot and on click of this, you might want to trigger the automate flow
and in the same flow you might want to refresh thepower bi dataset as well
well using power bi api ,you can refresh power bi dataset so you could store your session details and session chats in that data set

if this helps in any way, please mark as solution