Trying to connect to my mySQL server with the desktop ,
and i keep getting this error - "A call to SSPI failed, see inner exception"
I checked everything , I have access to server , I manage to login with user passworkd from other systems like WorkBench ,
Help ?? 🙂
Right now it works by unchecking "Encrypt connections" option in "Edit Permissions" window of Data Source settings.
This is possible in Power BI Desktop.
How to do this in PowerBI Service?
I had this issue and fixed it by unchecking "Encrypt Connection" in Data Source Settings (thank to @anilreddy128).
I don't know how that checkbox turned on (Power BI Desktop update - September 2019 ?)
My model refreshes correctly in Power BI Service for a while. I suppose encryption was turned off when I deployed it previously. Maybe you should re-publish your PBIX.
Same problem here.
It has to be related to SSL encryption.
As soon as SSL/TLS was enabled at the MySQL server, problem occurs. Just a note, that encryption is not mandatory at the MySQL side, I can connect via MySQL workbench either with plain nor encrypted connection.
Has anyone found solution ?
I have had the same issue over recent weeks, I'm afraid I don't know how to fix it BUT I do know how to work around it.
All you need to do is setup ODBC connection(s) to your MySQL database(s) and then chose the ODBC connection method from Power BI "Get Data" menu.
You'll be able to select the ODBC database from there and choose the tables you need or if you select the Advanced option you can commit a SQL statement as you would do if the MySQL connection option was working.
A side point, I have this issue with 2 of the 3 MySQL servers I use, 1 of them however works absolutely fine through the connection so I can only imagine the issue is server side....but that's about as far as my technical capabilities extend 🙂
Hope that helps
In your scenario, how did you connect to MySQL, via "MySQL Database" data source type in desktop? Based on my research about the error message "A call to SSPI failed, see inner exception", it seems the issue can be caused by the windows update, see: A call to SSPI failed, see inner exception - The Local Security Authority cannot be contacted.
Also please verify you are using correct server and database name, and authentication, credential when connecting to MySQL database. Please use the latest desktop version 2.38.4491.282. And enable desktop trace log to see if you can find useful information.
I connected to the mySQL via Get Data->Databese->MySQL in the desktop tool .
I also understood this is something with Microsoft authentication or "name pipe" issye ,
but I dont understand how to fix it .
I downloaded the latest version from power BI site
I connected to the mySQL server with user/pass on another tool just to verify my credentials
nothing works !
thats it - we can not work with the tool anymore .
All my PC's and servers in the office could not connect with the PowerBY desktop to my DB .
I need urgent help , or we are loosing this tool to a diffrent one.
Hi, can you please send us the traces via Send A Frown?
(Steps: Options > Diagnostics > Tracing > Enable Tracing (Verbose) & Open Traces folder, and then reproduce your failure, close PBI Desktop, get the traces from Traces folder)