Forum Discussion
PowerBi chatbot in Copilot Studio
okay i got a plugin like
run a query against dataset I gave my workspace, dataset but in query what should I give? beacause i dont want to query for a specific visual or measure in my dashboard . I wanted to be dynamic like any a question I ask wrt to the dashboard I made i must get the answer from the chatbot.
Hi LB_Team , Thank you for reaching out to the Microsoft Community Forum.
Publish your dataset to a Pro or Premium workspace in the Power BI service and make sure your dataset contains correct field names, clean measures and proper date table. Once published, open the report and check the Copilot pane to verify that natural language querying is enabled, this step allows Copilot and external tools like chatbots to interpret questions based on your semantic model.
Next, go to Microsoft Copilot Studio and create your chatbot. You can define topics or intents like show sales this month or compare revenue over time. To access your Power BI data, you can either use Copilot’s built-in understanding of your published dataset or create a Power Automate flow that queries the dataset using the Power BI REST API and returns results back to the bot. Once set up, test the chatbot with real questions to make sure it returns the right answers.
Official Microsoft Copilot Studio documentation - Microsoft Copilot Studio | Microsoft Learn
How to Create a Chatbot | Microsoft Copilot
Use Copilot with Power BI reports and semantic models - Power BI | Microsoft Learn
Ask Copilot for data from your model - Power BI | Microsoft Learn
Mastering Data Analytics with Copilot: Power BI Integration (Part 2) | Microsoft Learn
the links provided below are wrt to copilot but not PVA (Copilot studio)
Hi LB_Team , Thank you for reaching out to the Microsoft Community Forum.
Thank you for clarifying. You’re right, the links I shared earlier were about the Power BI Copilot experience within reports, not Copilot Studio specifically.
Since you’re using Copilot Studio and want your chatbot to answer questions like “Who are the top 5 customers?” I suggest using the Run a query against Power BI dataset plugin in Copilot Studio, which you’ve already found. This plugin requires a DAX query rather than natural language. To make this dynamic, you can set up your flow to interpret natural language input, convert it to a DAX query and send it to the plugin via Power Automate.
Although Copilot Studio doesn’t yet fully support free-form questions for Power BI, this approach allows for dynamic interaction with your dataset.
Hi LB_Team - did you have any luck with your solution? I am currently trying to make a copilot studio agent that is able to take in natural language questions -> turn them into DAX queries -> return information to users in natural language. Any tips would be greatly appreciated if you were successful.