Forum Discussion
Creating a custom chatbot in Power BI using GPT.
I’ve been trying to build this by creating a custom visual using Node.js, but I keep running into multiple errors one after another, making the process quite frustrating.
Is there an alternative or easier method to integrate a GPT-based chatbot in Power BI— web service, or embedding an external app—without having to build a custom visual from scratch? I just want my own chatbot on PBI. Any guidance or step-by-step approach would be really helpful.
Please check if this link useful to you,
Hi Lakhbir ,
Thank you for engaging with the Microsoft Fabric Community. You don’t need to build a custom visual from scratch there are much easier ways to add a GPT based chatbot to Power BI. You can use the LLM Chatbot custom visual or Power BI Embedded Analytics, both of which are supported within Microsoft’ ecosystem, making integration smoother and more reliable.
Here a link to the LLM Chatbot visual on AppSource LLM Chatbot
Additionally, I found similar discussions in the Power BI community that might provide further ideas or solutions relevant to your case. Hope this helps.
Solved: Chat widget integration in power bi dashboard - Microsoft Fabric Community
Re: ChatBot integration - Microsoft Fabric Community
I hope this helps. Did I answer your question? Mark my post as a solution.
7 Replies
Please check if this link useful to you,
Hi Lakhbir ,
Thank you for engaging with the Microsoft Fabric Community. You don’t need to build a custom visual from scratch there are much easier ways to add a GPT based chatbot to Power BI. You can use the LLM Chatbot custom visual or Power BI Embedded Analytics, both of which are supported within Microsoft’ ecosystem, making integration smoother and more reliable.
Here a link to the LLM Chatbot visual on AppSource LLM Chatbot
Additionally, I found similar discussions in the Power BI community that might provide further ideas or solutions relevant to your case. Hope this helps.
Solved: Chat widget integration in power bi dashboard - Microsoft Fabric Community
Re: ChatBot integration - Microsoft Fabric Community
I hope this helps. Did I answer your question? Mark my post as a solution.
Hi Lakhbir ,
Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.
Thank You.
Hi Lakhbir ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.Hi Lakhbir ,
Could you let us know if your issue has been resolved or if you are still experiencing difficulties? Your feedback is valuable to the community and can help others facing similar problems.
Thank You.
Of course, yes, here is the link there is the Free option with 34k tokens
https://chatpowerbi.ai/Best regards
Hi Lakhbir,
Building a GPT-based chatbot directly as a custom Power BI visual can indeed be quite challenging. The development environment for visuals (Node.js + pbiviz SDK) is not really designed for complex AI workflows, which is why many developers run into errors and maintenance issues.
A more practical approach is usually one of these:
1️⃣ External AI service + API
You can host the AI logic outside Power BI (for example using Azure OpenAI or another LLM service) and let a small interface inside the report send questions to that service.
The service then translates the question into queries against the semantic model and returns the results.2️⃣ Embedded web app
Another common approach is embedding a small web interface (for example via an iframe or custom visual container) that handles the conversational interaction while Power BI continues to provide the data model.
This avoids having to build and maintain a full custom visual.
We recently experimented with a conversational interface embedded directly inside Power BI reports where users can ask questions such as:
• What is the best-performing product?
• Which region has the highest revenue growth?
• What is the margin trend this quarter?The interface interprets the question and queries the underlying semantic model so users can explore insights without navigating the report manually.
I recorded a short demo showing the interaction:
Curious to hear if others here are experimenting with similar conversational analytics approaches in Power BI.
