Forum Discussion
How to Set Up Scheduled Refresh for MySQL (ODBC) in Power BI Service?
Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
Install and configure the on-premises data gateway in standard mode on the machine where your ODBC setup is active. Next, create a matching System DSN using MySQL Connector ODBC 8.0.33, replicating the Desktop configuration with secure, read-only service account credentials instead of root or admin access, and test the connection. Then, in Power BI Service, register the ODBC data source with the gateway, map your published dataset to it using the same credentials, and verify the setup. Finally, enable scheduled refresh in the dataset settings, setting a frequency and times and monitor the refresh history to ensure smooth performance and address any issues.
If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Super UserPlease describe what "Remote" means. Is it directly visible from the Azure service?
Hi lbendlin
The data is hosted on a web hosting platform called Hostinger. It uses a MySQL database to store the data, and phpMyAdmin is provided as the management tool for accessing and managing the database.
- lbendlin
So on the open interwebs and anyone can access it ? In that case you would not need a gateway.
the MySQL database is hosted on Hostinger and is accessible over the internet using a public hostname and port. There's no VPN or firewall restriction blocking outside access.