AI Business Solutions (ABS)
Cloud and AI Platform
Agentify your business processes (Core)
Build a unified, governed data and AI estate (Core)
Scale business processes with agent-powered finance (Core)
Modernize your data to drive results and leverage AI (Core)
Intermediate
Microsoft Power BIAccelerate data insights with Copilot in Power BI
Copilot helps you use the transformational power of generative AI to get the most from your data. In this workshop you will learn how to prepare your data for use in Copilot for Power BI. You will also learn about the use of prompts and DAX queries as well as other Copilot capabilities for Power BI.
8 hours(Suggested: 2 days, 4h/day)TechnicalProject ReadyHands-on Labs
MS Course ID: 00039
Last Updated: Jul 1, 2025
Course Syllabus
1
Module 1: Building reports with Copilot in Power BI
• Overview of Copilot for Power BI
• Enable Fabric Copilot for Power BI
• Access Copilot in Power BI Desktop
• Update your data model to work well with Copilot for Power BI
• Create reports in the Power BI service with Copilot
• Create reports in Power BI Desktop with Copilot
• Ask Copilot questions about data in the model (preview)
• Write Copilot prompts for creating report pages in Power BI
• Create a narrative visual of a page with Copilot for Power BI
• Summarize a report in the Copilot pane
180 mins
Lecture
2
Interactive Simulated Lab
• Lab 1: Enable Fabric Copilot for Power BI to use it for Power BIservice and Power BI Desktop
• Lab 2: Create reports in the Power BI service and Power BIDesktop with Copilot
• Lab 3: Get answers from Copilot about data in the model
• Lab 4: Write Copilot prompts for creating report pages in PowerBI
• Lab 5: Create a narrative with Copilot for Power BI
• Lab 6: Summarize a report in the Copilot pane
60 mins
Lab
3
Module 2: Working with Copilot prompts
• Write Copilot prompts to create narrative visuals in Power BI
• Chat with your data
• Copilot DAX query features
• Use Copilot to write and explain DAX queries
• Use Copilot to create measure descriptions (preview)
• Enhance QandA with Copilot for Power BI
• Ask Copilot for data from your model (preview)
• Use Copilot preview features in Power BI
• Build your own Copilot solution accelerator for your coworkers
• Overview of Copilot in Fabric and Power BI
180 mins
Lecture
4
Interactive Simulated Lab
• Lab 1: Write Copilot prompts to create narrative visuals in Power BI
• Lab 2: Write and explain DAX queries using Copilot
• Lab 3: Use Copilot to create measure descriptions
• Lab 4: Use natural language to enhance QandA with Copilot for Power BI
• Lab 5: Ask Copilot for data from your model
• Lab 6: Work with chat-magics and Data Engineering chat panel in Microsoft Fabric notebooks
• Lab 7: Use the Copilot chat pane, code completion and quick actions for Synapse Data Warehouse
• Lab 8: Access the Real-Time Intelligence Copilot and improve the accuracy
60 mins
Lab
What You'll Learn
Understand core concepts and best practices
Hands-on experience with real-world scenarios
Learn from certified Microsoft experts
Prepare for relevant certifications
Access to lab environments
Post-training support and resources
Course Details
- Duration
- 8 hours
- Level
- Intermediate
- Role
- Technical
- Readiness Stage
- Project Ready
- Audience Segment
- Enterprise, SMB
- FY27 Key Workload (Core)
- D365 + Power Platform + Copilot Studio, Fabric + Data + Foundry + MS IQ
- Course Stage
- Available
- Hands-on Labs
- Yes
- Labs Platform
- StepUp