Write Copilot prompts for creating report pages in Power BI

Article
04/25/2024

APPLIES TO: Power BI Desktop Power BI service

Before your business can start using Copilot capabilities in Power BI, your administrator needs to enable Copilot in Microsoft Fabric.

Note

Your administrator needs to enable Copilot in Microsoft Fabric.
Your F64 or P1 capacity needs to be in one of the regions listed in this article, Fabric region availability. If it isn't, you can't use Copilot.
Your administrator needs to enable the tenant switch before you start using Copilot. See the article Copilot tenant settings for details.
If your tenant or capacity is outside the US or France, Copilot is disabled by default unless your Fabric tenant admin enables the Data sent to Azure OpenAI can be processed outside your tenant's geographic region, compliance boundary, or national cloud instance tenant setting in the Fabric Admin portal.
Copilot in Microsoft Fabric isn't supported on trial SKUs. Only paid SKUs (F64 or higher, or P1 or higher) are supported.

Sample prompts for report pages

Here are some examples of prompts that work well with Copilot for Power BI. Use these prompts as examples.

Each sample prompt is paired with a report page that Copilot generated based on the interpretation of that prompt. Your prompts help Copilot understand what you're looking for, but they may not produce a page that's exactly what you want. It's a starting point for report page creation. Use the user interface to modify the report page that Copilot created.

Sales performance by product

"Create a page to analyze the sales amount, revenue, and profit margin of different products, categories, and subcategories over time and across regions."

Customer segmentation and loyalty

"Create a page to identify and compare the characteristics, behaviors, and preferences of different customer segments based on demographic, geographic, and transactional data."

Promotion effectiveness and ROI

"Create a page to evaluate the impact and return on investment of various promotions on sales, revenue, and customer acquisition and retention."

Inventory and supply chain management

"Create a page to monitor and optimize the inventory levels, reorder points, safety stock, and product costs of different products and product lines based on demand, lead time, and manufacturing costs."

Create a table of contents

Now generate a table of contents across your report pages.

"Make a table of contents for this report that contains a brief description of what each page is about."

Send feedback

We always welcome your feedback about our products. Especially during public preview, your feedback helps us improve the product faster.