Forum Discussion

aphillabaum's avatar
aphillabaum
New Member
10 years ago

ODBC Error with Amazon Redshift - String data right truncation

I'm getting this error when trying to pull data from my RedShift data warehouse.

 

ODBC error: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [Amazon][ODBC] (10160) String data right truncation: String data is too big for the output data buffer and has been truncated..

 

The error seems to indicate that it was successful, but Power BI is taking it as an error... and not proceeding. Any idea how to advance past this?

 

--

Adam

4 Replies

  • arify's avatar
    arify
    Microsoft Employee

    Hi, this is a known issue, it should be fixed in the next release. Can you try it out when it's released? It should be very soon

    • aphillabaum's avatar
      aphillabaum
      New Member

      I'd love to try it out when it's released. Can you give me a slightly more specific idea about when it will be released? This week? Next week? Next month? Before September? Thanks!

      • arify's avatar
        arify
        Microsoft Employee

        Probably this week (even more probably today :smileyhappy: )