MetricSign
EN|NLRequest Access
Medium severitydata source

Power BI Refresh Error:
AzurePostgreSqlNpgsqlDataTypeNotSupported

What does this error mean?

A PostgreSQL column data type is not supported by the ADF Npgsql connector — certain PostgreSQL-specific types cannot be directly read.

Common causes

  • 1The PostgreSQL table contains a column with a type such as arrays, hstore, composite types, or custom domain types not supported by Npgsql in ADF
  • 2A tsvector, tsquery, or geometric type column is included in the copy
  • 3A recently added PostgreSQL extension type is not yet supported by the ADF Npgsql driver version

How to fix it

  1. 1Identify the unsupported column from the error message and exclude it from the copy activity.
  2. 2Use a SQL query in the PostgreSQL source to cast the unsupported column to a supported type: CAST(col AS TEXT).
  3. 3Upgrade the self-hosted integration runtime to the latest version for newer Npgsql driver support.

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/connector-troubleshoot-postgresql

Other data source errors