Showing results for 
Search instead for 
Did you mean: 
New Member

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?





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

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!

Probably this week (even more probably today Smiley Happy )

In here


Go to Advanced Download Options, and in the Details part of the page, you can see the version number & date

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors