MetricSign
EN|NLRequest Access
Medium severitydata source

Power BI Refresh Error:
DF-SAPODATA-StageAuthInvalid

What does this error mean?

The authentication credentials for the staging storage used by the SAP OData connector are invalid. The Blob Storage or ADLS Gen2 account key, SAS token, or managed identity used for staging has been revoked or changed.

Common causes

  • 1The storage account key used in the staging linked service was rotated or regenerated
  • 2A SAS token for the staging container expired
  • 3The ADF managed identity no longer has Storage Blob Data Contributor on the staging container
  • 4The staging linked service was updated to a different storage account without updating the credentials

How to fix it

  1. 1In ADF Studio, open the staging linked service (the Blob or ADLS linked service used for SAP OData staging).
  2. 2Click 'Test connection' — if it fails, update the account key or regenerate the SAS token.
  3. 3If using managed identity auth: in the Azure portal, check the staging storage account > Access Control (IAM) and confirm the ADF managed identity has Storage Blob Data Contributor.
  4. 4If using a Key Vault reference for the storage key, verify the Key Vault secret is current and the linked service reference is pointing to the latest version.
  5. 5Re-publish the linked service and re-run the pipeline to confirm staging auth succeeds.

Frequently asked questions

Does this error affect all pipeline runs or just the current one?

Depends on the root cause. A persistent misconfiguration fails every run; a transient issue may resolve on retry. Check the run history.

Can this error appear in Azure Data Factory and Microsoft Fabric pipelines?

Yes — the same connector errors appear in both ADF and Fabric Data Factory pipelines.

How do I see the full error detail for an ADF pipeline failure?

In ADF Monitor, click the failed run, then the failed activity. The detail pane shows the error code, message, and sub-error codes.

Will downstream Power BI datasets be affected when an ADF pipeline fails?

Yes — a dataset refreshing after the pipeline will use stale data or fail if the target table was cleared. The Power BI refresh may succeed while serving wrong data.

Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide

Other data source errors