Forum Discussion
Access MySQL onPremise (non Azure installation) with SSL Certificate / How to use the certificate
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.