Forum Discussion
Solved
PowerBi chatbot in Copilot Studio
Hi everyone, I'm exploring the idea of building a chatbot using Copilot Studio (formerly Power Virtual Agents) that can answer natural language questions based on a Power BI dataset for example: ...
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.
- Publish your Power BI dataset to a Premium or PPU workspace.
- Go to Copilot Studio > Create a Copilot.
- In your bot, go to Plugins > Enable Power BI plugin > Connect to your dataset.
- Create topics with trigger phrases (e.g., "This month's sales").
- Add Power BI plugin in topic to run natural language queries.
- Test and publish the bot to Teams or Web.
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.