Chatbot to fetch PowerBI Report data

Hi hoosha_11 ,
Thanks for using Fabric Community,
Thanks andrewsommer  for your valuable response,

Agree with your approach of using the Azure OpenAI API and Power BI REST API or XMLA endpoint. It’s a solid strategy to create a chatbot for natural language queries.

Additionally, I wanted to mention the Semantic Model support with AI Skill introduced in the February Fabric update. It allows for easier integration of structured business data and automatic translation of user queries into DAX, simplifying the process and reducing the need for multiple prompts. This could align well with your approach and improve the chatbot experience.
Fabric February 2025 Feature Summary | Microsoft Fabric Blog | Microsoft Fabric

Hope this helps. Please reach out for further assistance.

Please consider marking the helpful reply as "Accepted Solution" to assist others with similar issues.

Thank you.