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.
