Chatbot to fetch PowerBI Report data

Microsoft just announced in the February Fabric update the Semantic Model support with AI Skill:

“The AI Skill now supports Semantic models, a new data source that enables AI Creators to integrate structured business data for natural language querying. Semantic Models provide a curated data layer that defines business logic, relationships, and aggregations, making it easier for users to analyze and explore data without needing deep technical expertise.

AI Creators can add Semantic models and selectively scope which tables are available for querying. Once configured, both AI Creators and consumers can ask natural language questions, which the AI Skill translates into DAX (Data Analysis Expressions) queries using LLMs. Users can trace the entire query process in the chat canvas, viewing how their input is interpreted, which transformations occur, and the exact DAX queries executed.”