Forum Discussion
Error via On Premises Data Gateway to SQL server
I have installed an On Premises gateway on a server.
I am able to access the SQL Server from the server on which the gateway is installed and the PBIX/report development was done from the same server.
But getting the error in Powerbi Service when trying to refresh the dataset/semantic model :
Error :
- 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":"Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)"}},{"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":"<<>>"}},{"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 - The received certificate has expired.)"}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2146893016"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}} Table: Query1.
So what should be the next steps?
Is there any settings within the gateway wherein we can exlcude encrypt credential similar to how we did in Powerbi desktop similar to below link :
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
3 Replies
Has nothing to do with the gateway. On the SQL server renew the expired certificates and then restart the SQL Server service.
Hey lbendlin
Thank you for your response.
But my query was more on :
We were able to connect to the database via Powerbi desktop by disabling encrypt connection, so is there any similar setting across On Prem gateway set up/Powerbi service.
There is not. We had a ticket open with Microsoft on that topic, and they swatted it away. They have no interest in allowing unencrypted connections on the gateway.
