Power BI Execution AI Agent

Job ID: 39564816

Budget: $30 – $250 USD

I'm looking to create an AI agent in Copilot Studio to help streamline locating Power BI dashboards pages that can answer data related business questions like "What was the Total Spend in 2024?" or "What is the overtime rate in California?". The agent will assist the user in answering multiple business questions, such as total spend by year or by business unit, not by loading the data but by pointing them to a report that can indeed answer their data question.

Key Requirements:
- Scan through existing workspaces and published Power BI reports based on my access.
- Identify relevant Power BI dashboard pages that can answer various business questions.
- Present findings in a Google search-like format, with clickable URLs for the most relevant reports.

Ideal Skills and Experience:
- Familiarity with AI agent development, particularly in Copilot Studio.
- Understanding how to connect to MCP servers such as PBIXRAY (https://playbooks.com/mcp/jonaolden-pbixray#claude-desktop-setup)
- Strong understanding ono how to connect AI Agents to MCP servers, etc.

Please provide examples of similar work done.
Related categories: AI Agents Model Context Protocol (MCP)