Data Agent: Support for SQL Views + Functions — Microsoft Fabric Roadmap

Description

SQL Views and Functions support in Data Agent enables the system to work with richer, production-grade SQL entities by incorporating views and reusable logic directly into query generation. This dramatically improves data accessibility, reduces complexity, and boosts NL2SQL accuracy by allowing Data Agent to rely on curated schemas, simplified naming, and pre-defined joins rather than raw underlying tables. The result is more reliable, performant, and business-friendly analytics experiences for creators and downstream users

📰 Related Blog Article

Data Agent Now Supports Eventhouse Functions, Materialized Views, and Shortcuts (Preview)

🔗 blog.fabric.microsoft.com

Change History

2026-04-22

Release Status Planned -> Shipped
2026-02-09

Release Date 2026-02-28 -> 2026-03-06
2026-02-09

Release Date 2025-09-30 -> 2026-02-28 Feature Description Data Agent only supports T-SQL Tables through the SQL Analytics Endpoint but production SQL systems heavily rely on Views and Functions to perform complex operations and scope data to a consumer's specific use case. Data Agent can leverage these Views and Functions to generate more complex queries. -> SQL Views and Functions support in Data Agent enables the system to work with richer production-grade SQL entities by incorporating views and reusable logic directly into query generation. This dramatically improves data accessibility reduces complexity and boosts NL2SQL accuracy by allowing Data Agent to rely on curated schemas simplified naming and pre-defined joins rather than raw underlying tables. The result is more reliable performant and business-friendly analytics experiences for creators and downstream users Name Data Agent: Support for SQL Views -> Data Agent: Support for SQL Views + Functions
2025-08-28

Roadmap Item Added