Connecting PowerBI to SQL server

[anshum]

I am on Server A and i have installed powerBI desktop for fetching data from SQL server and prepare visualizations. I am trying to connect to Server B from PowerBI which is on Server A. I am getting this error -
we are unable to connect to the data source using an encrypted connection. To access this data source using an unencrypted connection, click ok.
When trying from unencrypted connection it didn't worked and gave error we couldn't authenticate with the credentials provided. Please try again. 
I am using the credentials which are used to connect to SQL server from SSMS, I checked the port which is set 1433. Other things, i have tried to remove the encrypt connection from powerBI settings. If i use the windows credentials too, it gives the same error. 

[Anonymous]

Hi @anshum ,

Please make sure Server A have access to the SQL Server on Server B.

For reference:

Configure SQL Server Database Engine for encryption - SQL Server | Microsoft Learn

Power Query SQL Server connector - Power Query | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.