The certificate chain was issued by an authority that is not trusted error in power BI desktop application. User trying to refresh data from power bi desktop application. User getting error 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 certificate chain was issued by an authority that is not trusted.). There is no error if user refresh power bi data from online portal. User using sql server data connection with power bi as data source.

Follow the step-by-step procedure below to resolve the power bi data source certificate not trusted error.

• Open Power BI desktop software application.
• Click on Transform Data from the ribbon section Data.
• Select Data source settings from the drop down.

• Select the power bi data source.
• Click on Edit Permissions to check or change the microsoft power bi data souce connection with sql server.

• Edit Permissions window will open. Click on the Edit present under Credentials.

• New window will open and you will find the current power bi data source connection type with sql server is selected as Microsoft account or Datatbase.

• You just need to switch the power bi data source sql server connection type to Windows.

• Keep the selection for Encryption (Encrypt connections) and Privacy Level (Public, Organizational, Private) as selected belore. CLickon OK finally.

• Now issue should be resolved. If user tries to refresh data from power BI desktop, there should not be any data refresh error.

You can follow the steps in the video below since many users more comfortable in video format FYR.

certificate chain not trusted sql server error microsoft power bi desktop | data refresh error