Incremental Refresh with AI functions

[Anonymous]

Hello,

i've been trying to apply incremental refresh to a dataset with over 20m rows after applying sentiment scores from the AI analytics function in the power bi after setting up the parameters and uploading to prem workspace then refreshing it times out most of the times and the one time it created the partitions it failed to only refresh the specified parameters (Checked with Sql Server studio the dataset table from the workspace) and tried to refresh everything but timed out, Also tried to refresh with dataflow provided me with this error after 7 hours.

Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourcePath]=AIFunctions [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: '{"error":{"code":"TokenExpired" "message":"Access token has expired resubmit with a new access token"}}' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=126118]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=126118]'. RootActivityId = 7657f034-d224-4592-8713-73b668818ae5.Param1 = [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=AIFunctions [Microsoft.Data.Mashup.ValueError.DataSourcePath]=AIFunctions [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException An error happened while reading data from the provider: '{"error":{"code":"TokenExpired" "message":"Access token has expired resubmit with a new access token"}}' [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=126118]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=126118] Request ID: 573ee2f7-e2ec-3e32-2fd0-eba33eac7f87.

[v-robertq-msft]

Hi, 

According to the error message, it seems that the refresh failed because the access token has expired.

If you want to get a solution for this kind of refresh problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin