Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
There are certain limitations to the current Data Factory in Microsoft Fabric features. Before submitting a support request, review the lists in this section to determine if you're experiencing a known limitation.
For service level outages or degradation notifications, check Microsoft Fabric support.
The following list describes the current limitations of pipelines in Data Factory in Microsoft Fabric.
The following table describes the resource limitations for pipelines in Data Factory in Microsoft Fabric.
Pipeline Resource | Default limit | Maximum limit |
---|---|---|
Total number of pipelines within a workspace | 5,000 | 5,000 |
Concurrent pipeline runs per workspace that's shared among all pipelines in workspace | 10,000 | 10,000 |
External activities like stored procedure, Web, Web Hook, and others | 3,000 | 3,000 |
Pipeline activities execution for Lookup, GetMetadata, and Delete | 1,000 | 1,000 |
Concurrent authoring operations, including test connection, browse folder list and table list, preview data, and so on | 200 | 200 |
Maximum activities per pipeline, which includes inner activities for containers | 80 | 120 |
Maximum parameters per pipeline | 50 | 50 |
ForEach items | 100,000 | 100,000 |
ForEach parallelism | 20 | 50 |
Lookup Activity item count | 5000 | 5000 |
Maximum queued runs per pipeline | 100 | 100 |
Characters per expression | 8,192 | 8,192 |
Maximum timeout for pipeline activity runs | 24 hours | 24 hours |
Bytes per object for pipeline objects | 200 KB | 200 KB |
Bytes per payload for each activity run | 896 KB | 896 KB |
Intelligent throughput optimization per copy activity run | Auto | 256 |
Concurrent intelligent throughput optimization per workspace | 400 | 400 |
Meta Data Entity Size limit in a factory | 2 GB | 2 GB |
The following list describes the limitations for Dataflow Gen2 in Data Factory in Microsoft Fabric.
MyColumn
and mycolumn
, while supported in Mashup, results in a "duplicate columns" error.The following table indicates the supported data types in specific storage locations.
Supported data types per storage location: | DataflowStagingLakehouse | Azure DB (SQL) Output | Azure Data Explorer Output | Fabric Lakehouse (LH) Output | Fabric Warehouse (WH) Output |
---|---|---|---|---|---|
Action | No | No | No | No | No |
Any | No | No | No | No | No |
Binary | No | No | No | No | No |
Currency | Yes | Yes | Yes | Yes | No |
DateTimeZone | Yes | Yes | Yes | No | No |
Duration | No | No | Yes | No | No |
Function | No | No | No | No | No |
None | No | No | No | No | No |
Null | No | No | No | No | No |
Time | Yes | Yes | No | No | No |
Type | No | No | No | No | No |
Structured (List, Record, Table) | No | No | No | No | No |
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today