Forum Discussion

cdj's avatar
cdj
Frequent Visitor
7 months ago

Fabric Pipeline Warehouse connection problem

In my data pipeline I have a look up activity that runs a stored procedure on my Warehouse. About once every 14 days i get this error:   ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Co...
data engineering
data pipeline
bariscihan's avatar
bariscihan
Resolver II
6 months ago

Hi,

Based on the error details you shared, the main issue appears to be related to temporary connectivity loss between the Fabric Pipeline runtime and the Warehouse SQL endpoint, rather than a permanent connector or permission configuration problem.

From the error message:

  • SqlFailedToConnect – Cannot connect to SQL Database

  • Inner SQL exception:
    “The operation could not be completed because the system was updated or access to the encryption key was lost…”

This typically indicates one of the following scenarios:

  1. Temporary Warehouse unavailability due to backend update or service reconfiguration on the Fabric platform.

  2. If you are using Customer-Managed Keys (CMK), there may be a temporary loss of access to the encryption key (for example: Key Vault access policy issue, key disabled, identity permission issue, or key rotation timing).

Since you mentioned this happens roughly once every ~14 days, this strongly suggests a platform-side maintenance or reconfiguration window, rather than a persistent configuration problem.

Recommended Mitigation Steps

1️⃣ Add Retry Logic to the Lookup Activity

Lookup activities do not always handle transient failures automatically.
I recommend configuring:

  • Retry count: 3–5

  • Retry interval: 2–5 minutes

This usually allows the Warehouse endpoint to recover automatically if the issue is caused by temporary backend operations.

2️⃣ If CMK Is Enabled – Validate Key Vault Configuration

If your Warehouse is encrypted with CMK, verify:

  • CMK is Enabled / Active in Azure Key Vault

  • No recent key rotation caused permission drift

  • Managed Identity or Service Principal used by Fabric still has:

    • Get

    • Unwrap Key

    • Wrap Key
      permissions

3️⃣ If Issue Persists – Open a Microsoft Support Ticket

Since the issue is periodic, providing timestamps helps backend engineers correlate with platform events.

You can create a support ticket here:
Create a Fabric and Power BI Support Ticket
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Useful Microsoft Documentation

Fabric Warehouse Connectivity
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

Fabric Warehouse Troubleshooting Guide
https://learn.microsoft.com/en-us/fabric/data-warehouse/troubleshoot-fabric-data-warehouse

If you can confirm whether CMK is enabled on your Warehouse and whether retries are already configured on the Lookup activity, we can narrow this down further and validate whether this is fully transient or configuration-related.

Hope this helps.