Connectivity

The certificate chain was issued by an authority that is not trusted

Error code: ssl-cert-untrusted

Power BI dataset refresh error — what it means and how to fix it.

What this means

An on-prem SQL self-signed certificate is not trusted (encrypt-by-default).

How to fix it

Add the servers to SqlTrustedServers on the gateway (PBI_SQL_TRUSTED_SERVERS in Desktop).
Or install a trusted CA certificate.

View on Microsoft Learn

Related connectivity errors

DM_GWPipeline_Gateway_DataSourceAccessError
DM_GWPipeline_Gateway_MashupDataAccessError
Login timeout expired
The server was not found or was not accessible (SQL error 40)
Connection denied — Deny Public Network Access (Azure SQL)
The server name doesn't match the SQL Server SSL certificate

Catch this automatically

RefreshRadar monitors every Power BI dataset refresh and alerts you the moment one fails — with the likely cause and the fix — so you never hear about a broken refresh from your stakeholders first.

Start free