Copilot for Real-Time Intelligence (preview)

Copilot for Real-Time Intelligence is an advanced AI tool designed to help you explore your data and extract valuable insights. You can input questions about your data, which are then automatically translated into Kusto Query Language (KQL) queries. Copilot streamlines the process of analyzing data for both experienced KQL users and citizen data scientists.

Important

This feature is in preview.

Prerequisites

• A workspace with a Microsoft Fabric-enabled capacity
• Read or write access to a KQL queryset

Note

• Your administrator needs to enable the tenant switch before you start using Copilot. See the article Copilot tenant settings for details.
• Your F64 or P1 capacity needs to be in one of the regions listed in this article, Fabric region availability.
• 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.
• Copilot in Fabric is currently rolling out in public preview and is expected to be available for all customers by end of March 2024.
• See the article Overview of Copilot in Fabric and Power BI for more information.

Access the Real-Time Intelligence Copilot

1. To access Copilot for Real-Time Intelligence, navigate to a new or existing KQL queryset.
2. Connect to a database. For more information, see Select a database
3. Select the Copilot button.
4. In the Copilot pane, enter your business question in natural language.
5. Press Enter. After a few seconds, Copilot will generate a KQL query based on your input. You can copy the query to the clipboard, or insert it directly in the KQL query editor. To run the query in the query editor, you must have write access to the KQL queryset.
6. Select the Run button to execute the query.

Note

• Copilot doesn't generate control commands.
• Copilot doesn't automatically run the generated KQL query. Users are advised to run the queries at their own discretion.

You can continue to ask questions and generate queries in the Copilot pane, but each question is evaluated separately and not connected to previous questions or their answers.

Improve the accuracy of Copilot for Real-Time Intelligence

Here are some tips that can help improve the accuracy of the KQL queries generated by Copilot:

• Start with simple natural language prompts, to learn the current capabilities and limitations. Then, gradually proceed to more complex prompts.
• State the task precisely, and avoid ambiguity. Imaging you shared the natural language prompt with few KQL experts from your team without adding oral instructions - would they be able to generate the correct query?
• Supply any relevant information that can help the model to generate the most accurate query. If you can, specify tables, operators or functions that are critical to the query.
• Prepare your database: Add docstring properties to describe common tables and columns. This might be redundant for descriptive names (for example, timestamp) but is critical to describe tables or columns with meaningless names. You don’t have to add docstring to tables or columns that are rarely used. For more information, see .alter table column-docstrings command.

Related content

• Privacy, security, and responsible use of Copilot for Real-Time Intelligence (preview)
• Copilot for Microsoft Fabric and Power BI: FAQ
• Overview of Copilot in Fabric and Power BI (preview)
• Query data in a KQL queryset