Introduction

Copilot in Power BI is an AI-powered assistant that helps you work with data more efficiently. Data authors can use Copilot to prepare semantic models and create reports. Power BI also offers features to help authors prepare their data for use with Copilot by business users.

In this module, you learn how to use Copilot in Power BI to assist with semantic model and report development tasks. You also learn how to prepare data for your organization to interact with curated data using natural language. By the end, you'll have the knowledge to use Copilot in Power BI to make data analysis and reporting easier and more effective.

Revision insight

• Copilot in Power BI accelerates semantic model and report development by turning natural language prompts into Power Query steps, DAX queries, measures, and report pages.
• Strong semantic models first: favor star or snowflake schema, validate relationships, and use Copilot to summarize the model and suggest gaps.
• DAX Query view + Copilot: describe the analysis, generate DAX, then optionally Update model with changes to create measures.
• Report creation: Copilot can generate pages, visuals, and summaries from prompts in Desktop and the Service.
• Prep data for AI: simplify schema names, hide technical columns, configure Verified answers, and write AI instructions to give business context.
• Consumers can use the Copilot pane to ask questions, summarize, and explore data with chat.