Score sentiment - DataSource.Error UnexpectedEndOfStream

[jennyrconnolly]

Hello,

I updated a Power BI report containing Text Analytics - Sentiment analysis. Everything seemed to refresh fine in Power Query for the score column and subsequent steps, but when I close & load I get this error:

Back in Power Query, I tried extracting a Length column for the field being analyzed and filtering to catch abnormally long reponses, and it generated this error message. 

I am using the current version:

Any advice please?

Thank you,

Jenny

[lbendlin]

Power Query string columns have a 32KB limit

[jennyrconnolly · Accepted solution]

Thank you @lbendlin 

That led me to investigate more and I found the problem - the column being analyzed was 'any' data type and a numeric value came in. I switched it to Text and now runs.