Edit

Create report pages with Copilot for the Power BI service

  • Article

APPLIES TO: Power BI Desktop Power BI service

When you use Copilot for Power BI, you can quickly create report pages with just a few clicks. Copilot can save you hours of effort building your report pages.

Screenshot showing Copilot creating internet sales trend report page.

Before you start

You may need to do some clean-up work on your dataset. Read the article Update your data model to work well with Copilot to see if you need to modify your semantic model so that Copilot will get insights from it.

Get started

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

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

  2. In the ribbon, select the Copilot icon.

    Tip

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

  3. In the Copilot pane, select Suggest content for this report. Copilot evaluates the data and makes suggestions.

    Screenshot showing Copilot pane, suggest content.

    Copilot suggests possible pages for your report.

    Screenshot showing Copilot suggesting pages.

  4. Select Create next to the first page you want Copilot to create.

    Screenshot showing selecting the Create page button.

    Copilot creates that page.

    Screenshot of Copilot creating the Sales Comparison page.

    Continue creating the pages that Copilot suggests. Otherwise select Create a report that shows and provide guidance on what you want in the report.

  5. If you need help with writing prompts that get you the report page you want, see Write Copilot prompts that produce results in Power BI for guidance.

Create a summary

You can also use Copilot for Power BI to create a narrative summary with just a few clicks. This narrative can summarize the entire report, specific pages, or even specific visuals. See Create a narrative summary visual with Copilot for Power BI to learn how.

Undo a page

After Copilot has generated the report, then you can review the page. You have the option to start over by selecting the Undo button. After you select the Undo button, Copilot starts over. The content on the page is removed and you start over with topic selection by either generating new topics or selecting the one from the top, when you first started.

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

We're continuously working to improve the quality of the report pages, including visuals and summaries generated by Copilot. Here are the current limitations.

  • You can't tell it which kind of visual to create.
  • Copilot can't modify the visuals after it has generated them.
  • Copilot can't add filters or set slicers if you specify them in the prompts. For example, if you say: "Create a sales report for the last 30 days." Copilot can't interpret 30 days as a date filter.
  • Copilot can't make layout changes. For example, if you tell Copilot to resize the visuals, or to align all the visuals perfectly, it won't work.
  • Copilot can't understand complex intent. For example, suppose you frame a prompt like: "Generate a report to show incidents by team, incident type, owner of the incident, and do this for only 30 days." This prompt is complex, and Copilot will probably generate irrelevant visuals.
  • Copilot doesn't produce a message for the skills that it doesn't support. For example, if you ask Copilot to edit or add a slicer, it won't complete the instruction successfully as mentioned above. Unfortunately, it will not give an error message either.

Next steps