Available with: Azure AI Foundry and Power BI
Information Technology scenario: Build analytics within Fabric
Scenario
Simplify creation of database analytics
The admin plans to create a separate DataFlow Gen2 pipeline by modifying the M Query to include a loop for multi-day data ingestion, serving as a backfill when daily tasks fail.
Copilot in Microsoft Fabric
Sample Prompt: Rewrite this M query by changing the relative date ‘yesterday’ to accept the ‘startDate’ and ‘endDate’ parameters in the string format of “MM/dd/yyyy”. Make sure to process in loop one day at a time as the original.
As there are multiple tables in the Lakehouse, the admin needs help to create complex custom SQL query. They decided to use the AI Skill help building the query.
Copilot in Microsoft Fabric
Sample Prompt: How many users are there with the Action Level 2 of CreateNewPublication during the last 30 days and 31-60 days ago? Separate them into two different columns. Please break down them by Profession and rank them from the most to the least users.
The admin wants to simplify the report by reducing the number of rows through grouping similar records together.
Copilot in Microsoft Fabric
Sample Prompt: Under the Profession column, I want to combine Product Management and Program Management as Product Management. Then group them together by Profession and apply sum to the other two columns.
While building the report in Power BI, the admin wants to emphasize the area of the data showing the highest Month Over Month growth.

Copilot in Power BI
Sample Prompt: Which profession had the highest increase in the product usage this month?
The admin determines which group saw the largest decline in publication activity and analyze how changes in the product usage might impact those users.

Copilot in Power BI
Sample Prompt: Which profession saw the most significant decline in publication activity? And what could be the potential impact of the increase/decrease in the product usage for those with the most significant decline?
The admin wants to create interactive experience and allows anyone with access to the report to ask questions to the data within the report.

Copilot in Power BI
Sample Prompt: Publication creator MOMs with profession Business Operations or Design & Creative
The content in this example scenario is for demonstration purposes only. You should evaluate how Copilot aligns with your organization’s business processes, regulatory requirements, and responsible AI principles.
What's next
Explore more Information Technology Scenarios
Information Technology Scenario LibraryStart using Copilot
Go to the Copilot app to try a new scenario now. Everyone can start with Copilot Chat and if you are licensed Microsoft 365 Copilot connects to your work data and apps.
Start using CopilotView all downloadable content
Download our functional scenario kits, scenario guides, and day in the life guides to accelerate your Copilot implementation.
View downloads