Integrating Copilot Studio Chatbot with Power BI Semantic Models for Natural Language KPI Queries

I am developing a Copilot Studio chatbot, and my goal is to enable users to ask for metrics or KPI-related information in natural language. The chatbot should then query existing Power BI semantic models (datasets) to retrieve the relevant data and provide answers.

I do not want to rely on DAX or SQL queries directly the interaction should be conversational, with the chatbot translating user intent into queries against Power BI datasets.

Currently, I am exploring the “Run query against Power BI datasets” capability and available tools, but I am stuck. I’m looking for guidance, best practices, or reference documentation that explains how to connect Copilot Studio with Power BI semantic models for natural language queries.