Forum Discussion
Access MySQL onPremise (non Azure installation) with SSL Certificate / How to use the certificate
Hi
sometimes i have to reach out for customer with onPremise Databases 😀. The are often secured with SSL Acces (Server/Client Certificates). I used those DB sources with STUNNELS with a local installation (using a 127.0.0.1:xxxx Access for PowerBI working!). But this Workaround is not transferable to PowerBI Service because the Access from the Service should not go via my desktop PC!
So i am looking for a solution to get access via SSL to this MySQL onPremis source (not using a vpn, no azure). I proofed the access with the MySQL Workbench using the SSL Client Certificate - working fine!
My questions are:
- Where do I have to put the Client Certificate an my Desktop for PowerBI Acces to this SSL based onPremise source? Searched the forum but got no helpful advices for this exact topic? Is there a principal method to use SSL Certificates for Powerbi?
- Where do I have to put the Client Certificate on the PowerBI Service (Gateway? - Encrypted Access does not ask me for the Certificate!?) to get access to this source? Or is it a matter of privacy?
Dont want to spend more time with trial and error approaches - so I ask the forum. Every hint is welcomed!
Regards
Josef
5 Replies
Hi jofujofu
Your data source is from MySQL and your data connection mode may be directquery, so you need to set gateway when you publish your report on Power BI Service.
Install Enterprise gateway instead of personal gateway (work as an application,can't be shared with others, can only be used in report with import mode), configure gateway correctly.
More info about installing gateway and On-premises data gateway in-depth
Then set gateway in dataset setting in Power BI Service.
You may refer to this blog for more details about Refresh data from an on-premises SQL Server database.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Rico!
the gateway is already installed as a Enterprise gateway.
Thanks for the Hints/Links - I'v red it. The mentioned Article: On-premises data gateway in-depth does not deal with the certificates. It adresses the certificate situation on Azure...
Found no solutions until now: So the question for me is, where do I have to put the client certificate by using it acessing the onPrem MySql database. Where/How do i have to use it on the PowerBI desktop and where in the PowerBI Service..
Regards
Josef
Hi jofujofu
After you publish you report, you can add your credential by steps as below.
Find your dataset in setting, select add to gateway in gateway connection.
Then you can add your data source in your gateway.
Select your Authentication Method, input your username and password.
For more info you can refer to this blog
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi jofujofu
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Rico Zhou
HI Rico!
thanks a lot for your hints. I'm on it to test... But need more time to evaluate the solution due to christmas reasons 😉 I'm back in january on this topic to give a feedback.
Regards
Josef
