cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Enable MySQL Data Source Encryption on Reporting Server

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

J67XOe7

 

 

jlXicTx

 

2 REPLIES 2
Helper III
Helper III

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.

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.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.