Calling Stored procedure giving error-the certificate chain issued by the authority is not trusted

[Anonymous]

In power bi selected transform data -> new source -> sql server -> entered sql server name, database name, selected advanced options -> entered exec storedproedure name. Clicking "OK" giving error - "Connection was successfully established with the server but then an error occurred during login process. The certificate chain was established by the authority is not trusted". Please suggest resolution for this issue.

[v-chuncz-msft]

@Anonymous 

You may check the following posts.

• https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only/m-p/359157#M15709
• https://community.powerbi.com/t5/Desktop/Authentication-options-for-SQL-Server/m-p/369948#M167680