metricsign
Start free
High severitygatewayMicrosoft Fabric

Power BI Refresh Error:
Fabric Copy Activity Error 20523

What does this error mean?

The on-premises data gateway (ODPG) version in use does not support managed identity credentials. The Copy Activity cannot authenticate using managed identity until the gateway is upgraded to a supported version.

Common causes

  • 1The on-premises data gateway is running an outdated version that predates managed identity support
  • 2Auto-update is disabled on the gateway machine, preventing automatic version upgrades
  • 3A managed identity authentication type was selected in the linked service without verifying gateway version compatibility
  • 4A gateway cluster with mixed versions where some nodes are below the minimum required version

How to fix it

  1. 1Step 1: Identify the current version of your on-premises data gateway by opening the gateway application on the host machine or checking it in the Fabric/Power BI admin portal under 'Manage gateways'.
  2. 2Step 2: Consult the Microsoft Fabric or Power BI documentation to find the minimum gateway version that supports managed identity credentials for your connector.
  3. 3Step 3: Download the latest on-premises data gateway installer from the official Microsoft download page and upgrade the gateway on the host machine.
  4. 4Step 4: After upgrading, restart the gateway service and verify the new version is reflected in the gateway management portal.
  5. 5Step 5: Re-run the Copy Activity to confirm managed identity authentication now succeeds with the upgraded gateway.

Frequently asked questions

Can I use an alternative authentication method temporarily while planning the gateway upgrade?

Yes. If your data source supports it, you can temporarily switch the linked service to a service principal (client ID and secret) or basic authentication method that is supported by the current gateway version. This allows pipelines to continue running while you schedule the gateway upgrade.

How do I enable auto-update on the on-premises data gateway to prevent version-related issues in the future?

Open the on-premises data gateway application on the host machine, go to Settings, and ensure the 'Update automatically' option is enabled. Note that gateway updates still require the gateway service to restart, so plan for a brief interruption during updates.

Other gateway errors