Text Analysis Sentiment Score not working with XLS datasource and privacy levels

[Pok]

Hello, I am encountering an error when using Power BI Score Sentiment Text Analytics with an XLS data source. The data source has the Privacy Level set to "Private" and I have also tried "Organization" and I am using an Organizational account.

If i turn privacy off it works but with privacy set on the AI function data source it produces this error.

The error message is:

Expression.Error. We cannot convert the "[Function]" to type Function
Details:
Value=[Function]
Type=[Type]

[Anonymous]

Hi @Pok ,

If I understand correctly, the issue is that you encountered the error when using power bi with an XLS data source. Please try the following methods and check if they can solve your problem:

1.Ensure that the privacy level for the XLS data source is set correctly.

Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn

2.Confirm that the connection to the data source is established correctly.

3.Check if there are any issues related to credentials.

4.You can view the following link to learn how to use text analytics.

Connect to AI Insights in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu