Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I use a On-premises data gateway for a SQL connection we have. It use to work fine but as of late the refreshes have stopped working and are giving authentication issues.
Failed to update data source credentials: MySQL: Retrieval of the RSA public key is not enabled for insecure connections.
After doing some research i found a article a bit old saying perphaps its due to ssl not enabled. But I'm not really finding where you manage this in the Gateway or on Power BI?
Running:
MySQL Connector NEt 8.0.29
On Premises Data Gateway (Personal Mode) - 3000.134.9 (July 2022)
Solved! Go to Solution.
You set that in the network settings of the gateway admin app for each gateway cluster member
You set that in the network settings of the gateway admin app for each gateway cluster member
Good to know in the future. I actually had a few different issues that I think all got resolved sense then. I switched to Standard gateway and that fixed alot of my problems. I also downgraded the SQL connector net back down to 8.0.28 the .29 version caused alot of problems.