Score Sentiment Stopped working July 1, 2024

[Jumpkicks]

We have a report with Score Sentiment that has been successfully refreshing for many months, as of July 1st it stopped refreshing on both Desktop and Web with the following Error:

DataSource.Error: An error happened while reading data from the provider: 'An internal error occurred.'
Details:
DataSourceKind=AIFunctions
DataSourcePath=AIFunctions
DataSourceKind.2=AdoDotNet
DataSourcePath.2=AI.Provider/

No change has been made to the report

[VF_Batchelor43]

Hey @Jumpkicks  It looks like a wider issue. I tried Power BI Service dataflow and Power BI destop, both not working for sentiment analysis.

Error message: 

Error: Encountered user gateway exception: '<ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourceKind.2]=AdoDotNet [Microsoft.Data.Mashup.ValueError.DataSourcePath]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourcePath.2]=AI.Provider/ [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException <ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=38388]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=38388]'. RootActivityId = 0359046b-6737-435e-b922-af4126910f30.Param1 = <ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingErrorMessage]=<ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourceKind.2]=AdoDotNet [Microsoft.Data.Mashup.ValueError.DataSourcePath]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourcePath.2]=AI.Provider/ [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException <ccon>An error happened while reading data from the provider: 'An internal error occurred.'</ccon> [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=38388]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=38388] Request ID: 72a2c766-0501-f2d8-c25f-d9db36fe8782.

Sample data:

createdon	surveyid	Comment
3/5/2024, 12:22:07 PM	223e0664-d69b-ec11-b400-000d3abe5c88	She was very concise, informative and professional.
3/5/2024, 6:23:03 PM	531b4044-2130-ed11-9db1-000d3a239c4e	Very friendly and patient service.\n
3/6/2024, 12:19:27 PM	223e0664-d69b-ec11-b400-000d3abe5c88	Apart from a bit of a longish wait for an operator, the service was perfect. Thank you.
3/6/2024, 2:32:34 PM	531b4044-2130-ed11-9db1-000d3a239c4e
3/6/2024, 6:50:14 PM	223e0664-d69b-ec11-b400-000d3abe5c88	Well done!
3/7/2024, 1:03:24 PM	531b4044-2130-ed11-9db1-000d3a239c4e	No comments. Thank you.
3/7/2024, 8:37:09 PM	531b4044-2130-ed11-9db1-000d3a239c4e	Efficient, very professional!
3/8/2024, 10:16:46 AM	223e0664-d69b-ec11-b400-000d3abe5c88	Not at this time. \n\nThus far the service I have received has been very positive though.

[joshrobbins]

@rnehrboss we're switching to Python (NLTK).

[rnehrboss]

@joshrobbins just spent the last few hours doing the same (switching to nltk).

Been in a nightmare where on-premise (personal) gateway wont import nltk (or anything else I'm pip install(ing).

Any thougths there?

When I pip install it goes to a path "C:\Users\User\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages"

I see the installed modules, but power bi refresh gives:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ADO.NET: Python script error.\r\nModuleNotFoundError: No module named 'nltk'\r\n</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Python"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"Python"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.ExceptionType","detail":{"type":1,"value":"Microsoft.PowerBI.Scripting.Python.Exceptions.PythonScriptRuntimeException"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Python script error.\r\n<pi>ModuleNotFoundError: No module named 'nltk'\r\n</pi>"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Table.
Cluster URI: WABI-US-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 79255ad2-8909-4e87-b41d-8eebdd946da3
Request ID: 06d21e6a-2f22-f74f-146a-eddc6976aa71
Time: 2024-07-17 21:57:38Z

if I run python from command prompt on the personal gateway machine, I can import and run nltk just fine.
python scripting on gateway works if I dont use any extra modules.

@Jumpkicks 

[Banzai]

Same issue here:

[SMB-AH]

I had this reply from MS support once I raised a ticket with them

Thank you for bringing the issue to our attention. We have investigated and found that this is an ongoing problem. The deployment to address this issue is scheduled between July 29th, 2024 and August 3rd, 2024. After that, you should no longer experience any difficulties. Please feel free to reach out to us in case of any difficulty in the future.

[newellsak]

@SMB-AH  Thanks. Will See.

[rnehrboss]

switched to python nltk - vader.. much faster .. 

[Anonymous]

Hi all , 

Score sentiment can work well in PBI Desktop (version 2.131.901.0 64-bit (July 2024) ) . You guys can update PBI Desktop to the current version and test it.

As for the refreshing issue with Service that you guys mentioned, it's a general problem. Fabric Customers with tenants located in Central US region may encounter issues while interacting with the service .  The issue has now been resolved, please verify on Service.

Best Regards,
Community Support Team _ Ailsa Tao

[newellsak]

@Anonymous           Thanks

Working Fine

[Anonymous]

@Anonymous - Can confirm this is working again for our tenant as well.

Thank you for your assistance!