Schedule refresh PowerBI to MySQL without gateway
I built a PowerBI dashboard that connects to a MySQL database. Currently this connection requires an on-prem gateway to schedule refresh in the service. I was wondering if it's possible to schedule refresh without the gateway. My device is very old and keeps giving me issues. Gemini told me to setup an Azure Database for MySQL but some people say I still need a gateway since it's not an Azure SQL database. The MySQL database is hosted on a Linux server so installing a gateway there also wouldn't work.
I'm willing to migrate but I'd like to make sure it will work before making a commitment. Thank you!
Apply tot his job
Apply To this Job