Issue decription:

Users are prompted with following error message while trying to connect to a SQL database using Power BI:

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.)”

Solution:

To solve this issue you can ask user to update connection settings as follows:

 For example you can use:

Server: USKIBPW1\MSSQLSERVER, 1433

Database: BPW_Datamarts

Where 1433 denotes the listener port for the SQL service.