Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article provides suggestions to troubleshoot common problems with the SQL database in Fabric connector in Data Factory in Microsoft Fabric.
Error code: Failed
Message:
Operation on target CopyJobActivityLoop failed: Activity failed because an inner activity failed; Inner activity name: CopyData_final, Error: The activity was running on gateway, but some cloud connections are incompatible with it. To ensure compatibility, enable the option "Allow this connection to be used with gateways."Cause: The SQL Database in Fabric connection must be enabled for gateway usage.
Recommendation: To resolve the issue, try these steps:
In the Microsoft Fabric portal, select Settings.
Select Manage connections and gateways, and select the connection with the SQL database in Fabric connection type.
Under Authentication settings, select Allow this connection to be utilized with either on-premises data gateways or VNet data gateways. This setting is required because copy operations run through a gateway runtime. If you don't enable the SQL Database in Fabric connection for gateway usage, data copy operations fail.
Select Save to save the connection.
For more information on creating Fabric SQL connections that work with on-premises data gateways, see Migrate to SQL database in Fabric with the Migration Assistant by using DACPAC.
Related content
For more troubleshooting help, try these resources: