Forum Discussion
Training course recommendation on learning Natural Language to SQL within SQL Server?
Hi D_PBI,
Thank you for reaching out to the Microsoft Fabric Community Forum.Natural Language-to-SQL (NL2SQL) is possible within the Microsoft ecosystem using Azure OpenAI, Copilot Studio, Microsoft Fabric, and Power BI Copilot. The quality of results depends on having a well-structured SQL Server data model with meaningful table and column names, clear relationships, documented business definitions, and appropriate security controls. AI can enable users to ask questions in plain English and generate SQL queries, but it is generally best used alongside Power BI rather than as a complete replacement, since Power BI continues to provide governed reporting, dashboards, KPIs, and visual analytics.
Since you are new to AI, a good starting point would be Microsoft's AI-900 Azure AI Fundamentals training, followed by learning about Azure OpenAI, Copilot Studio, and Fabric Copilot capabilities. I would also recommend building a small proof of concept using a subset of your SQL Server data to evaluate answer quality, security requirements, and business adoption before considering a broader implementation. This approach will help determine whether Natural Language querying can effectively support your reporting and analytics needs.Refer these links:
1. https://learn.microsoft.com/en-us/fabric/fundamentals/copilot-fabric-overview?
2. https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction?
Hope this helps. If you have any questions regarding this, please feel free to reach out to us. We will be happy to help.
Hi D_PBI,
Thank you for reaching out to the Microsoft Fabric Community Forum.
Natural Language-to-SQL (NL2SQL) is possible within the Microsoft ecosystem using Azure OpenAI, Copilot Studio, Microsoft Fabric, and Power BI Copilot. The quality of results depends on having a well-structured SQL Server data model with meaningful table and column names, clear relationships, documented business definitions, and appropriate security controls. AI can enable users to ask questions in plain English and generate SQL queries, but it is generally best used alongside Power BI rather than as a complete replacement, since Power BI continues to provide governed reporting, dashboards, KPIs, and visual analytics.
Since you are new to AI, a good starting point would be Microsoft's AI-900 Azure AI Fundamentals training, followed by learning about Azure OpenAI, Copilot Studio, and Fabric Copilot capabilities. I would also recommend building a small proof of concept using a subset of your SQL Server data to evaluate answer quality, security requirements, and business adoption before considering a broader implementation. This approach will help determine whether Natural Language querying can effectively support your reporting and analytics needs.
Refer these links:
1. https://learn.microsoft.com/en-us/fabric/fundamentals/copilot-fabric-overview?
2. https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction?
Hope this helps. If you have any questions regarding this, please feel free to reach out to us. We will be happy to help.
Hi D_PBI,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi D_PBI,
Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.