SQL Server Get Data fails... cannot fathom why

randyvolters Check out this related link with the how/why of the Encryption message. I saw that today at a client, and he was able to pass through and access the database after clicking ok on the warning message.

Have you checked the SQL logs or Event Viewer for any errors when you try to log in? This should lead you to an answer as to why your creds are being rejected. If you are positive that your creds are good and you have access to the database (which it sounds like you are) - then I would delete the cached data source as there might be something that got messed up in it initially or since last connection. You can delete the Power BI Cached data source by going to File -> options -> Data Source Settings -> global -> (Select the offending data source) -> clear permissions and a delete data source prompt will pop up. Delete the data source. And try to re-connect to the SQL instance.