scheduled refrech failed

Hello, 

Please i need your help, i build a report in power bi where my source of data is from SSMS, i imported tables and i modify them in power query, then i have scheduled an automatic refresh in power bi service using gateway(personnal mode). now when i refresh in power bi desktop it done without any problem but in power bi service it gives me this error can you please clarifiy to me the source of problem. 

The message error" Erreur de source de données{"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":"Microsoft SQL : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"20"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"100912sql1;live_100912"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"53"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: rpt_adAttendanceDetail_vw.

• URI du clusterWABI-EUROPE-NORTH-B-redirect.analysis.windows.net
• ID d'activité5c3c58f4-7af5-4b12-8942-74cda7bd9005
• ID de demande7d3b90e0-4350-40a0-8381-03dfc74d617a
• Heure2023-07-07 08:19:32Z" Thank you