How to: Use the Copilot Explain and Fix quick action features for SQL database in Fabric
Applies to: ✅ SQL database in Microsoft Fabric
There are two AI-powered quick actions that are currently supported in Copilot for SQL database: Explain and Fix.
Quick actions can accelerate productivity by helping you write and understand queries faster. These buttons are located at the top of the SQL query editor, near the Run button.
The Explain quick action leaves a summary at the top of the query and in-line code comments throughout the query to describe what the query is doing.
The Fix quick action fixes errors in your query syntax or logic. After running a SQL query and being met with an error, you can fix your queries easily. Copilot will automatically take the SQL error message into context when fixing your query. Copilot will also leave a comment indicating where and how it has edited the T-SQL code.
Copilot uses information about your database schema, query tab contents, and execution results to give you relevant and useful feedback on your query.
Prerequisites
- Your administrator needs to enable the tenant switch before you start using Copilot. For more information, see Copilot tenant settings.
- 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.
- For more information, see Overview of Copilot in Fabric and Power BI.
Get started
Whether you're a beginner or an expert in writing SQL queries, quick actions allow you to understand and navigate the complexities of the SQL language to easily solve issues independently.
Explain
To use Copilot to explain your queries, follow these steps:
Highlight the query that you want Copilot to explain. You can select the whole query or just a part of it.
Select the Explain button in the toolbar. Copilot analyzes your query and generates inline comments that explain what your code does. If applicable, Copilot leaves a summary at the top of the query as well. The comments appear next to the relevant lines of code in your query editor.
Review the comments that Copilot generated. You can edit or delete them if you want. You can also undo the changes if you don't like them, or make further edits.
Fix
To get Copilot's help with fixing an error in your query, follow these steps:
Write and run your query as usual. If there are any errors, you'll see them in the output pane.
Highlight the query that you want to fix. You can select the whole query or just a part of it.
Select the Fix button in the toolbar. This button will only be enabled after you run your T-SQL query and it has returned an error.
Copilot analyzes your query and tries to find the best way to fix it. It will also add comments to explain what it fixed and why.
Review the changes that Copilot made and select Run to execute the fixed query. You can also undo the changes if you don't like them, or make further edits.
