Enable MySQL Data Source Encryption on Reporting Server

[kyleegbert]

I have created a simple power bi report in desktop, connected to an internal MySQL (MariaDB) database, which enforces connecting using SSL (but does not require certificate files).  On desktop, the data load works correctly.  When this report gets saved to our reporting server, I cannot configure the data source for the file to connect using the same credentials & authentication mode.  I am guessing that it isn't using encryption, but needs to, and I can't find a parameter to enable to inform the server to do so.  On the desktop, there is a single checkbox to use encryption, but I cannot find the same option anywhere within the reporting server.

Reporting Server & Desktop Version: August 2018

[RobThrive]

I know this is an old thread. I had the same issue as @kyleegbert  but couldn't find the solution when using mySQL driver and SSL in PBI. I already had the CA cert installed on the box, the relevent mySQL drivers etc and it all worked perfectly from the PBI desktop client, just not working from report server.

In the end my solution was to create a system DSN (windows start menu --> ODBC), then in PowerBI use ODBC as your data source rather than mySQL. Do this ensures that the system DSN is able to take care of the SSL cert needed, and specify the default database to connect to.

Hope this helps anyone else who stumbles across this post.

[kyleegbert]

Wanted to report that I did the same as @RobThrive but didn't think to update this feed.  Still - I'd love it if it was enabled within PBI directly.  In my company, we share SSAS resources and I need to make a request to have DSN's setup for each and every little connection I need, which isn't ideal for such a common data source.