Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 d...
Data Source Error
Encryption Support
Mysql
RobThrive's avatar
RobThrive
Resolver I
5 years ago

I know this is an old thread. I had the same issue as Anonymous  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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.