Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

Add GENERATE_SERIES support to Fabric Data Warehouse

Request to add GENERATE_SERIES function to Fabric Data Warehouse, consistent with
SQL Server 2022 and Azure SQL Database (compatibility level 160).

 

Business Use Case:
- Loading date dimension tables efficiently
- Generating number sequences for ETL processes
- Eliminating dependency on tally/numbers tables
- Simplifying data generation scripts

 

This feature would improve code portability between SQL Server 2022, Azure SQL DB,
and Fabric Data Warehouse, reducing migration friction and maintenance overhead.

Status: New