IT scenario: Build analytics within Fabric
Available with: Azure AI Studio and Power BI Scenario level:
KPIs impacted
IT management costs
Value benefit
Reduce costs
Using Copilot to build analytics within fabric
1. Building data pipeline
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.
2. Ingesting the data from Lakehouse
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.
3. Transform the data
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.
4. Building positive narrative
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?
5. Building an impact analysis
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?
6. Interactive experience
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
1Access Copilot at copilot.microsoft.com or the Microsoft Copilot mobile app and set toggle to “Web”.
2Access Business Chat at copilot.microsoft.com or the Microsoft Copilot mobile app and set toggle to “Web”.
3Copilot agents allow Microsoft 365 Copilot to access your company-specific apps. In the past, this would have required an API call to get data from a system of record. 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.
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.
