Forum Discussion
[Refresh on Power BI Service][MySQL]
Dear Power BI community, I have connected my Power BI Desktop file with Sharepoint and an external remote MYSQL server, Now I would like to publish it to the Power BI Service, and have scheduled...
Hi, I'm sorry but I'm pretty sure that mysql is a database that requires a gateway because it requires the instalation of a provider to read data. When you have onpremise and directly conected data be sure to have this option activated in gateway configuration:
You will need to set up a VM or any computer with access to the mysql server. Install a gateway and the plugin for mysql. Restart the vm restarted after the installation. Then you will be able to configure it in service to schedule refresh the dataset.
Hope this helps,