Score sentiment - text analytics - Hebrew support issue

Hey OriBy ,

Few things to consider:

1. Check Azure Cognitive Services Settings: Ensure that the Azure Cognitive Services endpoint you're using has sentiment analysis support for Hebrew enabled. While the "he" language code is mentioned in the documentation, there could be specific configuration issues or service limitations affecting its functionality.

2. Text Encoding and Cleanliness: Verify that the Hebrew text is correctly encoded. Sometimes, special characters or encoding mismatches can lead to unexpected results in text analytics.

3. Sentiment Analysis API: You can also try using a different approach, such as calling the sentiment analysis API directly through Power Automate if Power Query's native function isn’t working as expected.

4. Limitations in Language Detection: Sometimes, the language detection might not be accurate for Hebrew, leading to null values. Try manually specifying the language code or preprocessing the text to ensure it's correctly identified as Hebrew.

If you found this solution helpful, please consider accepting it and giving it a kudos (Like) it’s greatly appreciated and helps others find the solution more easily.

Best Regards,
Nasif Azam