0

I'm using Power BI Desktop with Amazon Redshift in DirectQuery mode. Data loads initially (sometimes at least / sometimes it has errors), but when I scroll down in a visual (e.g., table), I eventually hit this error:

ODBC Error: ERROR [42883] ERROR: function pg_catalog.date_add("unknown", double precision, timestamp without time zone) does not exist

It seems Power BI is trying to use a date_add function from pg_catalog, but that function doesn't exist in Redshift.

My question is: Is there a workaround or fix to prevent this error? Can I solve it by adjusting column types or applying transformations?

Improve this question
1
  • I think you are asking the right question as Redshift has the dateadd() function (no underscore). PowerBI likely just needs to be configured to use the correct SQL function names. Commented Oct 8 at 15:32
Related questions
1111
PostgreSQL error: Fatal: role "username" does not exist
1039
psql: FATAL: database "<user>" does not exist
790
psql: FATAL: role "postgres" does not exist
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.