Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have created a report in PowerBi Desktop which uses the new Text Analytics functions (score sentiment & extract key phrases). I have published this report to my premium workspace and scheduled a refresh, but the refreshes through the gateway (manual and scheduled) are failing with the error:
"The connection string used for the mashup data source is invalid or the gateway needs to be upgraded to the latest version"
I've verified the following:
All of my other datasets on this same workspace using this same gateway are refreshing normally, but this particular dataset using the new AI functions continues to fail when refreshed.
Unfortunately upgrading to the November 2019 version of the on-premise gateway doesn't appear to have fully corrected the issue. Although I am now getting a different error:
Underlying error message: | We cannot convert the value "[Function]" to type Function. |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.Reason: | Expression.Error |
I read here that this particular error message may be an issue with data source permissions, but setting everything to "Organizational" doesn't appear to have fixed it either.
Thanks for the feedback @GilbertQ. I'll wait for the November Gateway release and give it a shot.