Create and edit reports in the Power BI service with Copilot

APPLIES TO: Power BI Desktop Power BI service

When you use Copilot for Power BI, you can quickly create and edit report pages using natural language prompts. Copilot can save you hours of effort building and refining your report pages.

You can also create reports with Copilot in Power BI Desktop.

Before you start

Read about all the ways Copilot can help you in the overview of Copilot for Power BI for more guidance before you start.

• You need to select a compatible workspace that you have write access to. It needs to be a workspace that's assigned to a Copilot-enabled capacity, in other words, a paid Fabric capacity or a Power BI Premium capacity (P1 or higher).

Use Copilot in the Power BI service for the first time

To use Copilot in the Power BI service, you need to ensure that reports are located in a workspace in the right capacity. The workspace must be in either Premium Power BI (P1 and above) or paid Fabric capacity.

Check your license type in the Workspace settings.

1. Select More to navigate to the Workspace settings.

   

2. Apply either Premium capacity or Fabric capacity to the workspace and use the X to exit workspace settings.

   

   You can see which license mode is applied to your workspace under Premium. If License modes are grayed out, this workspace doesn't have access to the appropriate capacity.

3. Now you're ready to create a report with Copilot in the Power BI service.

Get started using Copilot

To see the Copilot button in your report, you first need to select a semantic model.

1. If this is your first time using Copilot in the Power BI service, see Use Fabric Copilot for Power BI in the service the first time.

2. Select the Data hub, then select More options (...) for the dataset you want to explore > Create report.

3. In the ribbon, select the Copilot icon.

   Tip

   If you don't see Copilot, your admins may not have enabled it in Microsoft Fabric, or you may not have selected a semantic model. Select a semantic model to see it.

4. In the Copilot pane, you can either select Suggest content for this report to have Copilot evaluate your data and makes suggestions, or enter a prompt directly to describe the report or visuals you want Copilot to create.

   

5. Copilot generates a report page based on your request.

   

6. You can further edit the report by prompting Copilot to add, delete, or change visuals.

   

7. If you need help with writing prompts, see Write Copilot prompts that produce results in Power BI for guidance.

Improved report creation and edits

With updates to report creation in the Power BI service, you can now work with Copilot to both create and edit report pages. These improvements provide more control, flexibility, and visual intelligence when building reports.

Smarter report creation

Copilot now delivers more accurate and relevant visuals, automatically selecting the best way to represent your data. It also supports a wider range of visual types, helping you present insights in the format that best fits your needs.

Flexible editing with Copilot

In addition to creating new pages, you can now:

• Add visuals to existing report pages.
• Change visuals by selecting new visual types or adjusting the fields used.
• Delete visuals that are no longer needed.
• Use undo and redo to easily reverse recent Copilot actions.

Save the report

When you're satisfied with the report, you save the report just like any other report. If you close and reopen the report that Copilot generated in the Power BI service, the report is in Reading view and you don't see Copilot.

• Select Edit to see the Copilot button again.

Considerations and limitations

There are limitations related to creating pages in specific semantic model scenarios.

• Q&A feature switch: The Q&A feature switch for your model must be turned on to use Copilot for report creation and editing.
• Real-Time Streaming Models: Report pages can't be created by Copilot for semantic models utilizing real-time streaming.
• Live Connection to Analysis Services: Semantic models connected live to Analysis Services aren't supported by page creation.
• Semantic models with implicit measures disabled: In scenarios where implicit measures are disabled in your semantic model, Copilot cannot create report pages.
• Custom visuals: Custom visuals aren't currently supported.
• Styling changes: Styling or formatting changes aren't supported through Copilot.
• Complex visuals: Changing complex visuals may result in some loss of detail or formatting.

Next steps

• Overview of Copilot for Power BI
• Create reports in Power BI Desktop with Copilot
• Create a narrative summary visual with Copilot for Power BI
• Privacy, security, and responsible use for Copilot for Fabric and Power BI
• Update your data model to work well with Copilot