If you haven’t already, check out Arun Ulag’s hero blog “FabCon and SQLCon 2026: Unifying databases and Fabric on a single, complete platform” for a complete look at all of our FabCon and SQLCon announcements across both Fabric and our database offerings.
Real-Time Dashboards in Microsoft Fabric give you a way to monitor live data and share insights with your team. Now, with Copilot integration in the dashboard editing experience, you can use natural language to create and modify visuals directly, no KQL expertise required.
This feature is designed for dashboard editors who want to build visuals without writing Kusto Query Language (KQL) queries from scratch. You describe what you want to see, and Copilot generates the query, returns the data, and suggests the best visual format for your answer.
New_tile_being_created_-_Copilot_pane_is_open_and_can_be_used_to_create_new_cont
Figure: New tile added to a dashboard with Copilot assistant.
The challenge of creating dashboard visuals
Building effective dashboard visuals typically requires two distinct skills: understanding your data and knowing how to query it. For many dashboard editors, the second part presents a barrier.This gap between knowing what insights you need and being able to extract them slows down dashboard development. Editors spend time looking up query syntax, debugging errors, and iterating on queries before they can focus on the actual presentation of their data.
The result is that dashboard creation often takes longer than it should, or editors depend on colleagues with KQL expertise to help build the visuals they need.
How Copilot helps dashboard editors
With this feature, Copilot is available directly in the dashboard’s visuals editing experience. When you're in Edit mode, whether creating a new visual or modifying an existing one, you can open the Copilot pane and ask questions about your data source in natural language.For example, you might type: "Show me the top 10 products by revenue in the last 30 days" or "What's the average response time by region?" Copilot interprets your question and generates a KQL query that retrieves the relevant data.
Real-time_dashboard_visual_in_edit_mode_after_Copilot_answer_has_been_applied
Figure: Real-time dashboard visual in edit mode after Copilot answer has been applied.
Copilot provides three outputs:
- Suggested visual: A chart or visualization type that fits the data
- Data table: A preview of the query results
- KQL query: The generated query that retrieves your data
Use cases for Copilot in dashboard editing
Quick visual creation
When you need to add a new tile to your dashboard, describe the insight you're looking for. Ask for aggregations ("total sales by category"), trends ("orders over the past week"), or comparisons ("top five regions by customer count"). Copilot handles the query logic, so you can focus on selecting the right visual format.Iterative refinement
Start with a broad question and narrow down based on the results. You might begin with "Show me all error events" and follow up with "Filter to critical errors only" or "Group by error type." Copilot maintains context within the conversation, so each follow-up builds on your previous requests.Enabling non-KQL experts
Business analysts and report creators who understand their data but aren't fluent in KQL can now build dashboard visuals independently. This reduces bottlenecks and lets teams iterate on dashboards without waiting for query support.Get started
To use Copilot when editing Real-Time Dashboard visuals, you need:- A workspace with a Microsoft Fabric-enabled capacity
- A Real-Time Dashboard with at least one data source connected
For step-by-step instructions, refer to the Copilot-assisted real-time data exploration documentation.
Next steps
- Learn more about Real-Time Dashboards in the Create a Real-Time Dashboard documentation.
- Submit ideas for new features through the Microsoft Fabric Ideas forum.
- Provide feedback on this feature using the feedback option in the Copilot pane.
