MetricSign
EN|NLRequest Access
Medium severitydata source

Power BI Refresh Error:
DF-SAPODP-StageBlobPropertyInvalid

What does this error mean?

A required property of the Azure Blob staging configuration for SAP ODP is incorrect or missing.

Common causes

  • 1The storage account name in the staging linked service does not match the actual Azure Blob storage account
  • 2The endpoint suffix is wrong — e.g. using .blob.core.chinacloudapi.cn in a global Azure environment or vice versa
  • 3The linked service was configured with a custom endpoint URL that is incorrect or unreachable
  • 4A pipeline was imported from a different environment and the staging linked service properties were not updated for the target environment

How to fix it

  1. 1In ADF Studio, open Manage > Linked services and open the staging linked service used by the SAP ODP source.
  2. 2Verify the storage account name matches the actual account in the Azure portal — names are case-sensitive.
  3. 3Check the endpoint suffix — for global Azure it should be .blob.core.windows.net; for China cloud use .blob.core.chinacloudapi.cn; for US Gov use .blob.core.usgovcloudapi.net.
  4. 4If the linked service uses a custom endpoint URL, verify the URL is exactly correct including protocol (https://) and trailing slash handling.
  5. 5Click Test connection to verify the corrected settings work before saving.
  6. 6Retry the pipeline after saving the corrected linked service.

Frequently asked questions

How is StageBlobPropertyInvalid different from StageAuthInvalid?

StageAuthInvalid means credentials (key, SAS, service principal) are wrong or expired. StageBlobPropertyInvalid means a structural property (account name, endpoint suffix) is wrong — it often fails before authentication when ADF resolves the endpoint.

Can this error appear after migrating a pipeline from dev to production?

Yes — this is the most common cause. Update the staging linked service for each environment; always include it in your pipeline migration checklist.

Does Test connection on the linked service catch this error?

Yes — for most property mismatches, Test connection will fail immediately. Always run Test connection after editing a linked service before retrying a pipeline.

Will downstream Power BI datasets be affected?

Yes — the pipeline cannot run without valid staging, so the target dataset will receive no new data.

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

Other data source errors