Forum Discussion

merinmione's avatar
merinmione
Helper I
6 years ago

Prepared statements? Amazon Redshift ODBC Error prepared statements

hi, i'm trying to connect to an Amazon redshift database to get Greenhouse data (recruiting system) but i keep getting an error.   DataSource.Error: ODBC: ERROR [42P05] [Microsoft][Amazon Redshift]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

No, I didn't have any luck.  GH referred me to their PostGreSQL alternative.  Which works, but is slower and will result in truncation errors for certain tables.

 

merinmione's avatar
merinmione
Helper I
5 years ago

After the back and forth between Msft and GH, I started using a data gateway to get to GH data and it resolved itself.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Are you using the Redshift connect in PBI or the PostGreSQL driver?

    • th340385's avatar
      th340385
      Helper I
      5 years ago

      I am using the Redshift connect in PBI. Everything worked great for the first 3 months. Randomly stopped working at the end of June.  

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        That was my experience as well.  We were about to deploy our reports when the June PBI update hit and everything stopped working.

    • merinmione's avatar
      merinmione
      Helper I
      5 years ago

      redshift

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Interesting.  Are you able to refresh from PBI desktop as well?