gateway issue with scheduled refresh

[Anonymous]

we have scheduled refresh for an report on daily basis. As we configured the gateway connectivity, as part of daily run, it fails to refresh the data. below is the error when we try refersh the data.

Fehler bei der Datenquelle: {"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 connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt.)"}},{"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":"server:\\ltssql3t;xyz"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - Die Zertifikatkette wurde von einer nicht vertrauenswürdigen Zertifizierungsstelle ausgestellt.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893019"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Gruppierungen.
Cluster-URI: WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net
Aktivitäts-ID: 41b75675-eccd-4c7a-b41f-6c22b382b496
Anforderungs-ID: e01ae028-e1d3-bc92-4ebb-712d8fc46245
Zeit: 2023-03-01 10:08:58Z

[v-yanjiang-msft]

There @Anonymous ,

Try the below steps:

1. Open your Power BI Desktop app
2. Click 'File'
3. Click 'Options and Settings'
4. Click 'Data Source settings'
5. Select the offending SQL server instance, from the list of data sources
6. Click 'Edit permissions' button at base of prompt screen
7. In this new prompt screen, under the 'Credentials' section, click the 'Edit' button to open a new prompt and select 'Windows'
8. Select either 'Use my current credentials' or 'Use alternate crednetials' (up to you, I just used mine)
9. Click' Save' button to close this prompt and return to the 'Edit Permissions' prompt screen.
   • In here there is an 'Encrypt connections' option. If your server accepts encrypted connections this will need to be ticked, mine doesn't and so I left it blank.
   • If you're not sure, don't worry. When you click 'Refresh All' a prompt will tell you if you need to be unencrypted and you can come back and untick this box.

Best regards,

Community Support Team_yanjiang