I'm trying to connect to our MySQL database via PBI Desktop (Version: 2.112.1161.0 64-bit (December 2022) using the MySQL connector. I'm able to make an intial connection but then get the "A call to SSPI failed, see inner exception" error. I'm able to access the server with no issues in MySQL Workbench using the same credentials. Searching the forom I found what appears to be a solution here: "A call to SSPI failed, see inner exception" -> HE... - Microsoft Power BI Community.
I've unchecked the Encrypt Connection option, clicked the OK button, then close. But....then what? If I go back to Get Data and select MySQL again, it's forgotten I made that change and I get the SSPI failed error again. Is there something in File > Options and settings I need to enable/disable?