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.
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.